making tables invisible/ locking users out of database forms/tables/queries/etc

[DBinPhilly]

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?

[ranman256]

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.


DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide


of course this could be byPassed with the shift key if they know that trick,
so then you must disable that!