Hello,
I would like to disable user access to all tables, queries, reports and forms except the one form that opens on start.
I've done a research and the way that comes up most often is to go to File > Options > Current Database and uncheck Use Access Special Keys, Display Navigation Pane, Allow Full Menus and Allow Default Shortcuts Menus. Then the only way to see the Pane and Menus is to hold Shift when opening DB. Let's say that's some kind of a protection because regular user probably don't know that and it's fine by me.
But in Access 2010 even if you do all that, there still are Privacy Options in File menu. Going there you can check all the options back, reopen the DB and you have full access again. So that's no protecion.
Is there an option to disable Privacy Options too? I know I can save my DB as .accde file but for some reasons I cannot/don't want to do that. Is there any other way to disable user access? Maybe some VBA code?
Any help would be really appreciated