I have a database consisting on the back end and the front end.
It will be placed on a network (NT) drive.
I want to disable people accessing the back end. The only access to it should be through the front end.
If CurrentUser() <> "YourLANName" Then
DoCmd.Quit
End If
Now make an autoexec macro using the RunCode action and select this function to run. Disable the shift key and you are set. No one except you will be able to open the database.
Another thought would be to go to the database properties by right clicking on it in Window's Explorer. Then select the hidden check box. Now no one will be able to see the database, even if they try to import from another database.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.