Others

Fix an OLE Server Registration Error in Microsoft Access

John WilsonJohn Wilson Nov 18, 2026 869 views

Question details

Resolve an OLE server error when an Access form exports a report to Excel after an Office migration.

Fix an OLE Server Registration Error in Microsoft Access
Product
Microsoft Access 2016 and Microsoft Excel
Device & OS
not provided
Scenario
A database migrated from Office 2010 to Microsoft 365 uses a form to generate an Excel report.
Observed behavior
Access displays an OLE server error when the form generates the report.
Before you start

Identify the form and button used to generate the Excel report, and check that you can open the form in Design View. Note the installed Office version and build, since the same macro setting may behave differently between builds.

Solution 1Recommended

Turn off Auto Start in the export macro

Use this fix if the form's embedded macro exports the report with ExportWithFormatting and has Auto Start enabled.

1
Open the form in Design View

In the Access Navigation Pane, right-click the form that generates the report and select Design View.

2
Inspect the control event

Select the button or control used to export the report. Open the Property Sheet, choose the Event tab, and open its embedded click-event macro.

3
Change the export setting

Find the ExportWithFormatting action and change its Auto Start property from Yes to No. Save the macro and the form.

4
Test the report

Open the form in Form View and use the export button again. If the export succeeds, open the resulting file in Excel.

Turn off Auto Start in the export macro
Office builds may behave differently: Auto Start set to Yes may work in one Access build but cause an error in another. Turning it off prevents Access from automatically opening the exported file.
Free Microsoft Office alternative

Open exported Excel reports with WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move exported reports into a new workflow. It does not fix Access OLE registration errors or run Access forms and macros.

Open and review Excel reports exported from AccessCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transitionFree and lightweight Office tools
microsoft office alternative - wps office

Frequently Asked Questions

Where is the Auto Start setting in Access?

Open the form in Design View, select the export control, and use the Property Sheet's Event tab to open its embedded macro. Look for Auto Start in the ExportWithFormatting action.

What happens when I set Auto Start to No?

Access will not automatically open the exported file after the export. Open the resulting file manually in Excel to check the report.

How can I tell which application is associated with an OLE object?

In the form's Design View, check the OLE control's Control Source in the Property Sheet. Then inspect that field in the underlying table's Datasheet View for clues about the associated application.

Can WPS Office fix the Access OLE server error?

No. The error must be troubleshot in Access and its associated Office applications. WPS Spreadsheets can open a compatible Excel report after it has been exported.