I am using Access 2007 on XP. I would like to ask how can I hide or completely disable showing the Navigation Pane? I have an autoexec macro that disables the F11 key, but that is not enough because user can click on that hideous Office Button->Access
Options->current database->check "Display Navigation Pane" and voila, it comes up again on the next load.
I don't want to go through the autoexec macro routine. I would like to ask, is there any way to totally disable the navigation pane and remove the above option from view via code. I am distributing this app to users and I don't want them to change
anything by accident.
Ideally, I would like to have it on launch to run some routine to disable the F11 key, remove that Office Button->Access Options->current database->check "Display Navigation Pane" option or at the very least from view. But at the same time,
I would have a routine to break it all back if I was to go into the vba editor and run that routine.
Thanks in advance for sharing your thoughts, sample code and/or user links.
1. Create an .accde file from your .accdb file (protects any VBA code)
2. Open the .accde file
3. Open Access Options--->Current Database and uncheck the Use Access Special Keys option (prevents using F11 to open the Navigation Pane and ALT+F11 to open the VBA window).
DO NOT DO THIS ON YOUR ORIGINAL .ACCDB FILE.