I need to lock a nosy user out of the tables on a database. This is a front end/back end application. I can lock the users out of the tables in the front end, but forget how to lock everyone out of the back end.
I know it's a simple solution but haven't had the need to do this in a decade. Now I forget how to do it.
Any suggestions?
you could set the properties of the BE file , and remove all his rights.
But if he still needs to use it, AND he knows the path to the backend, I dont know how you stop him besides tattling.
I have a table ,tUsers , of those allowed in. When the app starts, it checks the list to see if they can be in.
If so, i Hide the tables.
of course this could be byPassed with the shift key if they know that trick,Code:DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
so then you must disable that!