Fix the Microsoft Access OLE Server or ActiveX Control Error
Question details
Resolve an OLE server or ActiveX control error that occurs when filtering a Microsoft Access form.

- 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.
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.
Clear the Access database cache on close
Use this setting when cached data may be causing inconsistent form filtering.
In the affected database, select File > Options.
Select Current Database, find Clear Cache on Close, and select its checkbox. Click OK.
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.

Check the form's source for OLE Object fields
Inspect the underlying table and query if the error persists or you are unsure whether the form uses an OLE Object field.
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.

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.




