Fix Microsoft Access Queries After an Office Update
Question details
Restore Microsoft Access queries, add-ins, and VBA code that stopped working after an Office update.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- An Office update was followed by problems with a database that uses multi-table queries, add-ins, and VBA code.
- Observed behavior
- Queries involving multiple tables fail or behave unexpectedly, and add-ins and VBA code no longer work.
Make a copy of the affected database and record the exact error messages and Office build. If the database is shared, ask other users to close it before running Compact and Repair.
Check Office updates and repair the Access database
Use this approach to check whether a later Office update or database repair resolves the issue.
In Access, select File > Account and record the version, build number, and update channel under Product Information. Check the update history for the update installed before the problem began.
On File > Account, select Update Options > Update Now if the option is available. Restart Access and test an affected query.
After making a copy and having other users close the database, open it in Access and select File > Info > Compact & Repair Database. Reopen the database and test the queries again.
If the issue remains, give the recorded build and error details to your IT administrator or Microsoft Support. Ask whether a rollback to a known working build is appropriate and follow Microsoft's instructions for your update channel.

Review Access VBA references, trust settings, and add-ins
Use these checks when VBA code or add-ins also stopped working.
Test and restore affected multi-table queries
Use this approach if specific queries still fail after update, repair, and reference checks.
Use WPS Office for documents and spreadsheets alongside Access
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format support for easier migration of documents and spreadsheets. It does not repair Access or replace Access databases, queries, VBA code, or add-ins.

Frequently Asked Questions
Where can I find my Access version and build number?
In Access, go to File > Account and look under Product Information. Record the version, build number, and update channel when reporting the problem.
Does a failed multi-table query mean my database is corrupted?
Not necessarily. Check the error message, joins, field names, linked data sources, and VBA references. You can inspect a query by right-clicking it in the Navigation Pane and selecting Design View or SQL View.
How do I find missing VBA references in Access?
Press Alt+F11 to open the VBA editor, then select Tools > References. Look for entries marked MISSING and identify the component needed before changing the reference.
What should I do if Compact and Repair does not fix the queries?
Test the affected queries in Design View or SQL View and compare them with a known-good database copy. If the errors continue, provide the query SQL, Office build, and exact error messages to Microsoft Support or an Access developer.
Can WPS Office repair an Access database?
No. WPS Office can work with documents and spreadsheets, but it does not repair Microsoft Access databases or run Access queries, VBA code, or add-ins.




