Fix Excel Power Query Refresh Errors for an Access Database
Question details
The user needs to refresh Excel Power Query connections to Access queries stored in a synchronized SharePoint folder.

- Product
- Microsoft Excel Power Query and Microsoft Access
- Device & OS
- not provided
- Scenario
- An Excel workbook connects to queries in Access databases that are synchronized through a SharePoint folder.
- Observed behavior
- Refresh fails with database locked, database cannot be opened, or Access Database Engine object-not-found errors.
Note the full error message and identify the Access database file and query used by the failing connection. Check the sync status of the database and whether anyone is currently editing it.
Check Synchronization and Test a Local Database Copy
Use this test to determine whether synchronization or an active database lock is contributing to the refresh failure.
In the sync app and File Explorer, check that the Access database is fully synchronized and available locally. Ask other users to close the database and stop any processes that may be using it.
Copy the database to a local folder outside the synchronized SharePoint folder. If it uses linked tables or other dependent files, make sure those sources are also accessible from the test copy.
In Excel, select Data > Get Data > From Database > From Microsoft Access Database, choose the local copy, and select the affected query or table.
Load the selected object and use Data > Refresh All. If the local copy refreshes but the synchronized copy does not, investigate sync status and concurrent access to the original database.

Verify the Access Object and Power Query Source
Use this solution when the error says a database object cannot be found.
Review the Access Database Engine and Collect Error Details
Use this solution if the database still cannot be opened or refreshed after the local test.
Work With Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheet files and moving between office suites. It does not fix Excel Power Query or Access Database Engine refresh errors.

Frequently Asked Questions
Why should I test a local copy of the Access database?
A local copy outside the synchronized folder helps isolate sync or concurrent-access issues. Connect to it in Excel through Data > Get Data > From Database > From Microsoft Access Database, then try refreshing.
What does an object-not-found error mean?
Excel may be pointing to a table or saved query that was renamed, removed, or is in a different database. Check the object name in Access and the Source and Navigation steps in Power Query.
How do I find my Excel version and bitness?
Select File > Account > About Excel. Record the version and whether it is 32-bit or 64-bit when reviewing Access Database Engine compatibility or requesting support.
Can WPS Office repair this Power Query connection?
No. The refresh error belongs to Excel Power Query and the Access Database Engine. WPS Spreadsheet is an alternative for opening and editing Excel files, but it does not repair that connection.




