Allow full menus without restart (1 Viewer)

[Access_Help]

I have disabled "File" ->"Options"->"Current Database" "Allow Full Menus".

I want to enable it from a password protected form from a click of a button without restarting the database.

I have the pass by shift key disabled.

Any vba scripts I can use to achieve this?

 

[vba_php]

this page: https://support.office.com/en-us/ar...property-d1cf24ab-ca65-4450-8917-93d83319b678 says this:

In a Microsoft Access database (.mdb or .accdb), you can add it by using the CreateProperty method and append it to the Properties collection of the Database object.

do you know how to do that?

 

[gemma-the-husky]

@Adam - without testing that, I think changing the property setting enables the action for NEXT session, not the current session which is what the OP wanted. I hesitate to say it can't be done though.

 

[GinaWhipp]

While you can't do this mid session you can set a Form to load on start up and set those properties accordingly based on who's logging on.