Use a Custom Microsoft Access Ribbon in an ACCDE File
Question details
Configure a custom Access ribbon so it appears in a distributed ACCDE file and in Access Runtime.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A custom ribbon in an ACCDB database must be available after the database is distributed as an ACCDE file.
- Observed behavior
- The custom ribbon needs to be stored and assigned in the database so it appears when the designated form opens.
Open the source ACCDB in the full version of Microsoft Access and identify the form that should display the ribbon. Make sure the database is trusted so that any ribbon callbacks can run.
Store and assign the custom ribbon before creating the ACCDE
Use this method to make a database-stored custom ribbon available when a form opens in Access or Access Runtime.
If the ribbon is already stored as custom XML in USysRibbons, open that table and identify its RibbonName. If it was created through File > Options > Customize Ribbon, use Import/Export > Export all customizations to export it.
Open the exported file in a text editor. If an initial Access command element such as <mso:cmd app="Access" dt="0" /> is present, remove it and prepare the remaining ribbon XML for USysRibbons. Check that the result is valid Office ribbon XML; exported customization markup may require adaptation.
If needed, create a table named USysRibbons with ID as an AutoNumber field, RibbonName as a Short Text field, and RibbonXml as a Long Text field. Add a record with a unique ribbon name and paste the valid ribbon XML into RibbonXml.
Close and reopen the database so Access loads the ribbon. Open the target form in Design View, open its Property Sheet, and select the ribbon in the form's Ribbon Name property on the Other tab. Save the form.
Choose Database Tools > Make ACCDE, save the ACCDE file, and open it in Access or Access Runtime. Open the assigned form and check that the custom tab appears and its controls work.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Office format compatibility make it easy to move common files between suites. It does not create or run Access ACCDE databases or fix Access ribbon configuration.

Frequently Asked Questions
Where do I assign a custom ribbon to an Access form?
Open the form in Design View, open the Property Sheet, and select the ribbon in the form's Ribbon Name property on the Other tab.
Why doesn't my ribbon name appear in the form properties?
Check that USysRibbons contains a RibbonName and valid RibbonXml, then close and reopen the database. Access loads custom ribbons when the database opens.
Can a custom ribbon appear in Access Runtime?
Yes. Store the ribbon XML in USysRibbons, assign its name to the form, and test the distributed ACCDE in Access Runtime. Any callbacks used by the ribbon must also work in the trusted database.
Can I edit the ribbon after creating the ACCDE?
Make ribbon and form design changes in the source ACCDB, then choose Database Tools > Make ACCDE to create a new distribution file.




