Password protect the Navigation Pane

Ken Milam
Ken Milam used Ask the Experts™
on
Is it possible to password protect the Navigation Pane (including F11) in Access?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
Can you give some info on what kind of protection you are seeking.
For start you can go to Options-> Current Database scroll a bit downwards and and uncheck the option to show Navigation Pane
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
No, you cannot.  You can hide it at startup as John mentioned, but anyone can get around that if they are determined.

 The best you can do is to turn off the nav pane, special function keys, and disable the shift key bypass in code, then distribute as a .accde.

You can also password protect the entire DB, but that would still let anyone in once they have the password.

Jim.
Ken MilamEngineer

Author

Commented:
Hello John,
Thanks for reply.  I can, and I did use the feature that you describe.  Toggling back and forth between the two scenarios, however, is problematic.

I often times need access to the nav pane, and the only way that I know to reveal the Nav pane is to undo the steps that you recommend above, thereby making the nav pane available to everyone who uses the database.  

I was hoping that I could place a password on the F11 key.  That way, I could effectively hide the Nav pane, and then, if I need access to the Nav Pane, hit F11 and be asked for a pasword to show the Nav pane on the local machine.

Does this make sense?

Thanks,
Ken
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Ken MilamEngineer

Author

Commented:
Sorry, Jim, I posted my reply to John before reading your reply.  Thanks
Distinguished Expert 2017

Commented:
When you distribute the FE, rename the extension to .accdr

This doesn't alter anything in the database, it is only a filename change after all, but if the user doesn't know the trick, it will work.  Essentially it tells Access to pretend to be the Runtime engine so the user cannot see any backstage stuff or put any objects into design view.  Be aware that you might have to add some custom menus because this option turns off all right-click menus since they are not available in the Runtime so test carefully.
ste5anSenior Developer

Commented:
Do you work alone on that database or do we talk about a distributed frontend?

In the second case:
Use a deployment script or batch, which creates a "protected" file and distribute it. When you need to work with the navigation pane, use the development version.
Joshua KinselComputer Programmer

Commented:
There is a handy vba module that will handle blocking  alt+F11 I use it daily.   If you would like I can send code. As far blocking the pane,  distribute as .accede (makes access executable only)
Software & Systems Engineer
Commented:
I am on mini vacations so no testing but this article seems to cover your needs : https://software-solutions-online.com/hideunhide-navigation-pane-access-vba/
Ken MilamEngineer

Author

Commented:
Thanks, John!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial