Others

Fix Microsoft Access Queries After an Office Update

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

Restore Microsoft Access queries, add-ins, and VBA code that stopped working after an Office update.

Fix Microsoft Access Queries 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.
Before you start

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.

Solution 1Recommended

Check Office updates and repair the Access database

Use this approach to check whether a later Office update or database repair resolves the issue.

1
Record the Office build

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.

2
Check for a later update

On File > Account, select Update Options > Update Now if the option is available. Restart Access and test an affected query.

3
Compact and repair

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.

4
Investigate rollback if needed

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.

Check Office updates and repair the Access database
Rollback considerations: Rolling back Office can remove security fixes and may be managed by your organization. Apply a supported later update when a fix is available.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXWork with spreadsheet data while Access database issues are investigatedUse a familiar interface for common document and spreadsheet tasksAccess a free, lightweight office suite
QA img-9

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.