[AccessD] Set Database Options in Code

Hide the Ribbon When Access Starts
Access Developer Reference

By default, Microsoft Office Access 2007 does not provide a method 
for hiding the Ribbon. This topic describes how to load a customized 
ribbon that hides all of the built-in tabs.

To load the customized ribbon when Access starts, you should store 
its settings in a table named USysRibbons.

The USysRibbons table must be created using specific column names in 
order for the Ribbon customizations to be implemented. The following 
table describes the settings to use when creating the USysRibbons table.
Column Name Data Type Description
RibbonName Text Contains the name of the custom ribbon to be 
associated with this customization.
RibbonXML Memo Contains the Ribbon Extensibility XML (RibbonX) that 
defines the Ribbon customization.

The following table describes the Ribbon customization settings to 
store in the USysRibbons table.
Column Name Value
RibbonName HideTheRibbon
RibbonXML <CustomUI 
xmlns="http://schemas.microsoft.com/office/2006/01/CustomUI"> <Ribbon 
startFromScratch="true"/></CustomUI>

Applying the Customized Ribbon When Access Starts

To implement a custom UI so that it is available when the application 
starts, do the following:
Follow the process described previously to make the customized ribbon 
available to the application.
Close and then restart the application.
Click the Microsoft Office Button
Button image
 and then click Access Options.
Click the Current Database option and then, in the Ribbon and Toolbar 
Options section, click the Ribbon Name list and select HideTheRibbon.
Close and restart the application.



At 12:00 PM 6/29/2007, you wrote:
>Of Gale Perez [galeper at gmail.com]
>Sent: 29 June 2007 00:40
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Access 2007: Set Database Options in Code
>
>I need to distribute copies of an Access 2007 db and would like to know if I
>can set the following in code:
>
>
>?         Add the user's FE and BE paths to the Trust Center's "Trusted
>Locations"; I tried adding it manually from my machine, but when I emailed
>it to the user, they were wiped out (maybe because those paths don't exist
>from my machine), so I had to go to each user's machine and add the paths.
>
>?         Hide the navigation pane (even though I check it not to show, the
>minimized bar is still there and users can still click on it to expand it)
>
>?         Hide all tabs (home, create, external data, db tools)  and disable
>shortcut menus - I checked the box to hide full menus and shortcut menus,
>but they still show up
>
>
>
>Thank you for any help!
>
>Gale