Seral years on and someone has just emailed me about this thread.
Unfortunately all the links in my posts are to my old (now defunct) website.
As its not possible to edit posts that are several years old, here are the current links:



Post #5
AFAIK you can't lock the navigation pane but you can remove it along with part or all of the ribbon.
You can find code to do these in several of my example apps including this one: https://isladogs.co.uk/control-application-interface

For greater security, there are lots of other things you can do to keep out all except the most determined hackers.
For example, save as ACCDE, encrypt with a password and more. See https://isladogs.co.uk/improve-security/ (3 articles)

Post #12
If security matters that much, you should encrypt your database with a password.
Although you'll need to tell users the password so they can get in, the encryption will prevent anyone reading your database in a text editor.
See another article on my website: https://isladogs.co.uk/compare-access-file-security (3 articles)

Hope that helps anyone finding this thread in the future!