Password Protect The Backend?

[Kylor]

I have a split database that is already in use by several users. Can I password protect just the backend without affecting the users?

 

[glynch]

You can change all access to the backend tables to go through queries, (ex: all forms populated and updated through queries rather than directly into the tables).

Then go into the properties of each query and set the "Run Permissions" to owner's. Go into Tools menu, select Security go into user and group acounts and permissions, restrict their access to the tables and grant them the rights they need to the queries.

Unless this is a small app, all of this is a lot of work and should be done right from the beginning of construction, but it could still be done if you have some coding experience.

Hope this helps.

 

[R. Hicks]

Open the BackEnd Database "Exclusive", then set the Password.

Now ..... you will have to delete all the table links in the FrontEnd and re-link the tables so that Access can register the Password. If you do not do this ... you will be prompted for the password every time the FrontEnd db is opened.

HTH
RDH