Others

Fix the Microsoft Access OLE Server or ActiveX Control Error

Rana GarciaRana Garcia Nov 20, 2026 869 views

Question details

Resolve an OLE server or ActiveX control error that occurs when filtering a Microsoft Access form.

Fix the Microsoft Access OLE Server or ActiveX Control Error
Product
Microsoft Access
Device & OS
not provided
Scenario
A form filters a query based on fields from a main table, potentially in a database opened by multiple users over a network.
Observed behavior
Filtering produces error 502473. Changing the form's Recordset Type from Dynaset to Snapshot works temporarily, but the error returns after reopening the database.
Before you start

Open the affected database in Access and identify the form and its underlying query. If other users open the database over a network, arrange a time to close and reopen it so you can test filtering again.

Solution 1Recommended

Clear the Access database cache on close

Use this setting when cached data may be causing inconsistent form filtering.

1
Open Access Options

In the affected database, select File > Options.

2
Enable cache clearing

Select Current Database, find Clear Cache on Close, and select its checkbox. Click OK.

3
Reopen and test

Close the database, reopen it, and apply the same filter to the form. If applicable, ask another user to test the filter over the network as well.

Clear the Access database cache on close
Test after reopening: The setting clears the cache when the database closes; enabling it alone does not verify that the filtering error is resolved.
Free Microsoft Office alternative

Work with Office documents and spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday document and spreadsheet work. It does not fix Access errors or replace Access forms and databases.

Use a familiar interface for everyday document and spreadsheet tasksOpen and edit common Microsoft Office formats, including DOCX and XLSXWork with spreadsheet tables and filters when an Access database is not requiredMove compatible files into a lightweight, free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is Clear Cache on Close in Access?

With the database open, select File > Options > Current Database, then find and select Clear Cache on Close. Click OK, close the database, and reopen it before testing.

How can I tell whether my query uses an OLE Object field?

Open the query in Design View to identify its source tables and fields. Then open each relevant table in Design View and check the Data Type column for OLE Object.

Why did switching the form to Snapshot only help temporarily?

Snapshot changes how the form's recordset behaves but may not address cached data or another underlying cause. Check the cache setting under File > Options > Current Database and retest after reopening.

Can WPS Office fix this Microsoft Access error?

No. The cache setting and Access form must be checked in Microsoft Access. WPS Office can handle compatible documents and spreadsheets, but it does not replace Access databases or forms.