In MS Access 2010, is there a way to turn off Backstage? 1

[BitZero]

I'm using Access 2010. Is there a way to turn off the "Backstage" (i.e. "File") tab at the top?

 

[tbclbd]

In order to turn off the "backstage"

1. Create a table in your database "USysRibbons", which has two fields "RibbonName" (Text) and "RibbonXML" (Memo). You will define which buttons should be available to the user in the RibbonXML field.

2. Add a record to USysRibbons

RibbonName = MainRibbon (or something that will let you know this is the Application default ribbon)

RibbonXML =
<customUI xmlns="

http://schemas.microsoft.com/office/2009/07/customui"

>
<ribbon startFromScratch="true">

</ribbon>

<backstage>
<button idMso="FileCloseDatabase" visible="false"/>
<button idMso="SaveObjectAs" visible="false"/>
<button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false"/>
<tab idMso="TabInfo" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
<tab idMso="TabNew" visible="false"/>
<tab idMso="TabPrint" visible="false"/>
<tab idMso="TabShare" visible="false"/>
<tab idMso="TabHelp" visible="false"/>
<button idMso="ApplicationOptionsDialog" visible="false"/>
<button idMso="FileExit" visible="false"/>
<tab idMso="TabRecent" visible="false"/>
</backstage>

</customUI>

3. In the File Options, go to Current Database. Then scroll halfway down until you get to "Ribbon and ToolBar Options". There is a combo box "Ribbon Name". Choose the name of the ribbon you want to be the default for the application. If the ribbon does not appear in the list, there is a problem with the code.

Good luck

 

[BitZero]

Thank you! That removed everything from the File tab, including the Privacy Options.

Is there also a way to make the red "File" at the top left go away?

 

[tbclbd]

There is no way of getting the "File" tab to disappear, but, you can modify which options are available to the users. I haven't done it in quite a few months, but I will go over my notes and get back to you.

 

[tbclbd]

To modify the ribbon

Holding Shift Key, open database.
Click on File/Customize Ribbon. The options available on the ribbon are listed on the right hand side of the screen, uncheck all.

Access will prompt you to close the database and then reopen. When you reopen the database normally, the FILE tab will appear, but there will be no available options. Your "Main Ribbon" will have replaced the access ribbon.

Hope this helps.

 

[BitZero]

Thanks - I appreciate your help.