Power Query Problems

Fix Excel Power Query Refresh Errors for an Access Database

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

The user needs to refresh Excel Power Query connections to Access queries stored in a synchronized SharePoint folder.

Fix Excel Power Query Refresh Errors for an Access Database
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.
Before you start

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.

Solution 1Recommended

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.

1
Check sync and access

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.

2
Test a local copy

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.

3
Connect to the copy

In Excel, select Data > Get Data > From Database > From Microsoft Access Database, choose the local copy, and select the affected query or table.

4
Refresh the test

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.

Check Synchronization and Test a Local Database Copy
Avoid removing lock files: Do not manually delete an Access lock file while the database may be in use. Confirm that all users and processes have closed the database first.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS files.Review spreadsheet data with a familiar interface.Use a lightweight office suite with a free option.Move existing Office documents into a familiar workspace.
microsoft office alternative - wps office

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.