Data Import & Export

Fix Access Database Cannot Be Opened or Locked in Power BI

Camila MilosovichCamila Milosovich Nov 4, 2026 869 views

Question details

The user needs to resolve a database locking issue preventing the import of a Microsoft Access database into Power BI.

Fix Access Database Cannot Be Opened or Locked in 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.
Before you start

Ensure that no other users on your local network currently have the target Microsoft Access database open, as this natively locks the file.

Solution 1Recommended

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.

1
Close all active connections

Save your work and completely close Microsoft Power BI, Power Query windows, and Microsoft Access.

2
Restart your computer

Reboot your machine to forcefully terminate any background instances of the Microsoft Mashup Evaluation Container that are holding the lock.

3
Re-attempt the data import

Open Power BI and start the data import process again from the ACCDB file before opening any other database management tools.

Close Applications and Restart the System
Warning on Manual Deletion: Do not attempt to manually delete the LACCDB file while Power Query is still connected, as this can corrupt your database.
Free Microsoft Office alternative

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. 1. Download and Install: Get the free WPS Office installer from the official website and complete the quick installation.
  2. 2. Prepare your Data: Export your complex databases to CSV or Excel formats and open them instantly in WPS Spreadsheet.
  3. 3. Edit without Limitations: Enjoy fast data editing, formatting, and filtering without background locking errors.
Seamless format compatibility with Microsoft Excel (.xlsx) and CSV files for fast, error-free data preparation.Lightweight installation that avoids heavy background lock files like LACCDB.Completely free alternative for Word, Excel, PowerPoint, and PDF editing.Familiar user interface designed for immediate productivity and easy migration.
microsoft office alternative - wps office

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.