Activating my Menu after Shutting it OFF from Access Options (1 Viewer)

[AccessV2.0]

To secure my database, I disable "Allow Full Menus" from the "Access Options".
As I develop the database I want to press a button from the secure database which will turn the menu back ON and allow me into "Access Options".
I've already used:
DoCmd.ShowToolbar "ribbon", acToolbarYes
DoCmd.SelectObject acTable, , True
But this does not allow me back into "Access Options".
Any thoughts?

 

[theDBguy]

Hi. I could be wrong, but I think any code approach you use would require a restart anyway. If so, simply hold down the Shift key when you're opening your file in dev mode.

 

[AccessV2.0]

Hi. I could be wrong, but I think any code approach you use would require a restart anyway. If so, simply hold down the Shift key when you're opening your file in dev mode.

I think you are correct about needing a restart. Just trying to be fancy.

 

[isladogs]

Yes - you would need to restart
See if this article gives you any further ideas on security:

Improve Access Security 2

This article explains how to apply various security measures to make your databases as secure as possible. An example app is used to illustrate the possible methods available

www.isladogs.co.uk