Software

Ask something
Discussion Locked

MS Access Menus Locked Down Accidentally

0 helpful
9 replies

by tomhunady

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

MS Access AllowFullMenus and AllowShortcutMenus
set to False, preventing anyone from making changes to db. This means I cannot find a way to restore any of these menus.

9 replies

by dklippert

If you hold the Shift key down when double clicking on the database to open it, you can go in and change your startup settings to AllowFullMenus and AllowShortcutMenus

by tomhunady

I have tried that already. It doesn't work :(

Any other ideas?

I am trying to use VBA to reset the properties before opening the database.

by dklippert

Works for me.
Try opening it and then closing.
It should be on your MRU list on the file menu. Hold down the SHIFT key while you open the database and the Startup options will be bypassed

by dklippert

MRU = Most Recently Used list. The list that appears at the bottom of the File menu.

by jboardman

What happens when you HOLD DOWN the shift key while opening the database? It should open in Admin view with everything available. As a last resort you can open a new, blank database and import everything (forms/queries/etc) from the "locked" database into the new one. Then you can setup the Start options as you wish.

This discussion is closed to new replies.