lock users from backend access

[Beth]

I have a db that was created by a third party. Administrators need to open
the db through the backend occasionally, but the default is to open directly
to the forms that were created.

Is there a way to put an administrator password on the backend so not all
users can shift/open?

thanks!

 

[Rick]

This is asked and answered many many times in here. Do a search.


The answer is "no". You can place the backend in a hidden file that most
users won't be able to find, but there is no way using only Microsoft Access
to lock them out of the backend and still access the data through the
front-end.


I have a db that was created by a third party. Administrators need to open
the db through the backend occasionally, but the default is to open directly
to the forms that were created.

Is there a way to put an administrator password on the backend so not all
users can shift/open?

thanks!

 

[Bruce Hensley]

Rick,

If there is an autoexec macro in the back end, or code associated with an on
open event of a startup form on the back end, will the code run when tables
in the back end are accessed from the front end?

If not, couldn't you add code to one of these to exit the back end if the
user logging in wasn't in the admin group?