ACCESS 2007: Programmatically hiding Nav Bar and Keeping User Out

[TomCarnahan]

I have many years experience with MS-Access, but only recently started working with Access 2007.

I am trying to "lock up" the database to keep users out of various things such as:

- NavBar
- Ribbon
- VBE

I used to use:

Application.SetOptions "<item to set>", <value>

I have tried everything I can think of but cannot lock the UI. Various keystrokes CTRL-G, F11, ALT-F11, etc. bring up unexpected behaviors and compromise my end result.

I tried the suggestions in Allen Browns article

http://allenbrowne.com/ser-69.html

but is doesn't seem to help.

I don't have the good fortune of obtaining the office development environment, so I have to make do with these work-arounds. Can anyone suggest how to:
[ul]
[li] Permanently hide the NavBar from the user [/li]
[li] Keep the ribbon from popping up[/li]
[li] Permanently disable special keys and builtin menus[/li]
[/ul]

Any help will be greatly appreciated.

-- Tom





--- Tom