Others

Use a Custom Microsoft Access Ribbon in an ACCDE File

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

Configure a custom Access ribbon so it appears in a distributed ACCDE file and in Access Runtime.

Use a Custom Microsoft Access Ribbon in an ACCDE File
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.
Before you start

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.

Solution 1Recommended

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.

1
Locate or export the ribbon XML

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.

2
Prepare exported customization XML

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.

3
Store the ribbon in USysRibbons

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.

4
Assign the ribbon to the form

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.

5
Create and test the ACCDE

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.

Test ribbon callbacks: A ribbon may depend on VBA callback procedures. Test its controls in the ACCDE and Access Runtime, not just the appearance of the tab.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTX.Use a familiar ribbon-style interface for common Office tasks.Work with documents, spreadsheets, and presentations in one lightweight suite.
microsoft office alternative - wps office

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.