Secure Backend

14 Sep 2006 9:13 PM

LDanix

Hello,

I have a backend database and several frontends. The database has sensitive
data that only users of one of the frontends are authorized to view and
alter. Is there some way to lock down access to the backend by unathorized
users, but allow the frontend access to the backend to access what is
authorized?

Thanks

15 Sep 2006 10:03 PM

Joan Wild

LDanix wrote:

> Hello,
>
> I have a backend database and several frontends. The database has
> sensitive data that only users of one of the frontends are authorized
> to view and alter.

Somehow I don't think you really mean this. Don't the other frontends need
to at least 'view' the data in the backend?

> Is there some way to lock down access to the
> backend by unathorized users, but allow the frontend access to the
> backend to access what is authorized?

You can remove all permissions from the tables in the backends, and then use
RWOP queries in the frontend for all data interaction.

See www.jmwild.com/RWOP.htm for an explanation.

--
Joan Wild
Microsoft Access MVP