In Access 2003, I used to use SetOptions to keep the users from having certain features on startup. However, with 2007, I am having difficulty preventing the user from:

1) Seeing the NavBar
2) Seeing the Ribbon
3) Getting to Right-click menus
4) Using special keys like CTRL-F1, F11, ALT-F11, etc.
5) Seeing code if the code has an error

I am also having problems getting the macro AutoKeys to work (for the Administrator only ... I have code that checks the user and ignores non-admins)

Any advice would be greatly appreciated.

Thanks,

__________________
--- Tom

Are you allowing the database window to be shown on startup? If so, try turning that off. And remember that you can get you can get the database window to show on startup in such a situation by opening the application while holding down the <SHIFT> key. The code will not start, however. That would have to be done in some other way.

__________________
Technical Support Electrician

I use "set properties" code to disable the "shift bypass". I have code to close the navbar and ribbon. I have not found any code to disable the QAT bar.

__________________
--- Tom

I am out of town without having my code available, otherwise I would post it.

__________________
--- Tom

I may not be able to help you. What I was mentioning is found in the Tools, Startup.. pull down menu. I program only part time when the application that I am responsible for needs to be changed.

__________________
Technical Support Electrician