Hide File menu option in Access Database

Question

I have hidden the Navigation Pane per MS https://support.microsoft.com/en-us/office/show-or-hide-the-navigation-pane-in-access-f4d2ea84-6154-4433-9e42-7af391401b14

I need to lock down the File menu option for a Accdb file because after disabling all features in File, Options (in an Accdb file) it appears a user is able to click File, Privacy Options and enable some features. Basically I want the user to only be able to use the default form that opens. That's it. So, how can I disable the File menu (All menus) where users cannot get to other db features that I have disabled?

Thank You

Answer 1

I used this on form load

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Answer 2

I followed the steps by creating the table and setting ribbon to "My Tab" - but the "File" menu option remains visible and enabled.

how can I hide/disable the "File" menu option?

thank you

Answer 3

I think you can not completely remove the File Menu. Read theDBGuy's blog for information on the backstage.

Answer 4

I followed the steps by creating the table and setting ribbon to "My Tab" - but the "File" menu option remains visible and enabled.

how can I hide/disable the "File" menu option?

thank you

Hi. Just in case it helps, you might take a look at this short article.

http://thedbguy.blogspot.com/2018/05/backstage-view.html

Answer 5

Perhaps you should look intocreating a custom ribbonfor this relational database application.

Pay particular attention to the option to "startFromScratch"