Fix Access Database Cannot Be Opened or Locked in Power BI
Question details
The user needs to resolve a database locking issue preventing the import of a Microsoft Access database into Power BI.

- Product
- Power BI, Microsoft Access
- Device & OS
- not provided
- Scenario
- Importing data from a local Access database (ACCDB) into Power BI using the Power Query engine.
- Observed behavior
- Power BI fails to import the ACCDB file, reporting that the database prevents opening or locking. The LACCDB locking file remains in use by the Microsoft Mashup Evaluation Container.
Ensure that no other users on your local network currently have the target Microsoft Access database open, as this natively locks the file.
Close Applications and Restart the System
The quickest way to release a stalled locking file (LACCDB) caused by a hung Power Query process.
When Power Query connects to an Access database, a temporary locking file (LACCDB) is generated. If Power BI or the Microsoft Mashup Evaluation Container hangs, this lock file is not released, preventing further access.
Save your work and completely close Microsoft Power BI, Power Query windows, and Microsoft Access.
Reboot your machine to forcefully terminate any background instances of the Microsoft Mashup Evaluation Container that are holding the lock.
Open Power BI and start the data import process again from the ACCDB file before opening any other database management tools.

Verify File and Network Permissions
Ensure the folder hosting the Access database has the correct read/write permissions for Power BI to operate.
Terminate Stalled Background Processes
Use Task Manager to close background evaluation containers without restarting the entire computer.
Looking for a lighter, faster alternative to Microsoft Office?
Heavy database engines and complex lock files can slow down your workflow. Simplify your daily tasks with WPS Office, a lightweight, highly compatible alternative for spreadsheets, documents, and presentations that avoids heavy background processes.
- 1. Download and Install: Get the free WPS Office installer from the official website and complete the quick installation.
- 2. Prepare your Data: Export your complex databases to CSV or Excel formats and open them instantly in WPS Spreadsheet.
- 3. Edit without Limitations: Enjoy fast data editing, formatting, and filtering without background locking errors.

Frequently Asked Questions
What is an LACCDB file and why does it appear?
An LACCDB file is a Microsoft Access lock file. It is automatically created when a database is opened to track which users are currently active and to prevent simultaneous conflicting edits. It disappears when all users and connections are closed.
Can I manually delete the LACCDB file if Power BI is stuck?
You should only attempt to delete the LACCDB file if you are absolutely certain no applications (including background Power Query processes) are connected to the database. Deleting it while connected can result in data corruption.
How can I avoid database locking issues when importing data?
A reliable workaround is to first export your necessary Access tables into flat files, such as Excel (.xlsx) or CSV formats. Importing these flat files into Power BI bypasses the Microsoft Access database locking mechanisms entirely.




