Making a database read-only for most, but still editable by author

[Guest]

I have the database split between a two front end databases and a back end.
One front end has full access forms, another has read-only forms.

Each of the three has a password, to limit access to those who are authorized.

The problem: Password protecting the back end, means the front end
databases don't have access to the data either. How do I make the back end
database password protected, but still grant the front end access to the data?

(Is there some vba statement that I could put in the front end, to grant
access to the data in the tables?)

 

[Jeff Conrad]

Hi Katie,

In each of the front ends delete all the table links.
Then relink all the tables to the backend. You will
be prompted for the password only once. That
information will then be saved in the System tables.
Subsequent opening of the front ends will not prompt
for the password.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message: