Hide Navigation Pane In ACCDE Files
I have never understood why after all the effort put into compiling Forms and Code in Compiled Access databases and then they leave the Navigation Pane exposed so that all Tables are revealed and accessible to end users. Sure you can hide the Navigation pane but anybody can go into Options and reveal that Pane.
This has been a major negative to Access for me for years ....
Ernesto Manríquez Mendoza commented
In your Form.Open routine.
There you go.
I believe the option to remove all the buttons in the ribbon including "file" in ACCDE files would be welcome. Especially to hide code, tables etc.. Also remove the shortcut key to open access. Right now VBA must be used to lock it down plus unchecking boxes in file, options, current database. When hiding ribbons it would be nice to have the option to leave a quick print, export, full print option for reports without creating a ribbon. Creating your own ribbon is not easy. It could be simplified.
Bill Mosca commented
The problem is that some developers (not me) allow users access to create ad hoc queries. Without the Nav Pane (or some home-grown database window, they would not be able to do that. So I think the appearance should be a choice during the compiling process.
If you create your own Custom Ribbon, you can certainly prevent the Options menu - and everything except a File>>Exit button from showing for that matter ... consequently not allowing access to the Nav Pane.