You may encounter the error 3045 – “Could not use database; file already in use” while opening or modifying the database in MS Access. It is one of the common run-time errors in the Access application. It occurs when you try to open a database that is already in use by different users or was previously opened in any other instance. The error usually occurs when accessing the database (.accdb/.mdb) located on a server/network. It happens because the Access database engine fails to read or generate the lock files.
The complete error message appears as:
"Could not use <name>; file already in use. Error 3045: The specified file is currently being used by another user or session."
Let’s discuss the reasons that may lead to such an error and the solutions to resolve it.
Causes of Access Database Error “file already in use”
Some possible causes of the “Could not use file; already in use” error in the Access database are as follows:
- Corrupt or missing lock files.
- Users lack create/write/delete rights in the database folder.
- The database you are trying to access is corrupted or damaged.
- Trying to update the database that is already open.
- You might be using an incorrect path to open the database.
- Microsoft Jet Database failed to generate the locking information file.
- If the error appeared immediately after a Windows Update or Microsoft Office update, the cause is likely a known bug patched by Microsoft
Methods to Fix Access Database Error ‘file already in use”
Below are some methods that can help you resolve the “file already in use” error in MS Access.
Method 1: Check and Provide Desired Permissions
The “file already in use” error can occur when you do not have permissions to modify the folder in which the database file is located. So, make sure you have the read, write, and create permissions for the folder where the database is stored. To check and provide permissions, follow these steps:
- Go to Program Files and search for the desired folder.
- Right-click on the folder and select Properties.
- Click Security Tab > Advanced.
- In the Advanced Settings window, click on Change Permissions.
- Select Administrators > Edit.
- Change the Apply to drop-down to This Folder, Subfolder, and Files.
- Select the Full Control box below the Allow column button.
- Click OK > Apply.
Method 2: Download Microsoft Office Updates
Some users have reported encountering the error ‘Could not use the path to the database.accdb; file already in use’ after downloading the MS Office updates, specifically for Office 2013 and Office 2016. However, Microsoft released other updates to fix the issues. To download the updates specific to your Office version, refer to this Microsoft Guide.
If you’ve recently upgraded your MS Office version or installed the latest updates, and are facing this error, you can try reverting back to the previous version or uninstalling the recent updates.
Method 3-Delete the Lock File (.laccdb / .ldb)
Sometimes, you may encounter “file already in use” error in Access due to lock information files. You may face this situation when a .laccdb or .ldb file remains after a crash or improper system shutdown. The lock file is deleted automatically when the user closes the database. If it persists, then Access assumes the database is still open and leads to this error. To resolve this, first make sure you’ve closed all Access sessions and then locate the database folder, find the lock file, and delete it manually.
Method 4: Check the Path of the Database
The “file already in use” error in MS Access can also occur if the path to the database.accdb file is incorrect. Make sure you’re opening the database using the standard UNC path. You can see the default path of the database using the following steps:
- Go to File > Options.
- In the Access Options window, check the path next to the Default database folder option.
Method 5: Close all Opened Access Files
You may also encounter the “file already in use” error if multiple Access database files are open. You can just close all the Access database files using the below steps:
- Place your cursor on the Taskbar and right-click on it.
- Click on Close all Windows.
Note: Modern Windows versions may not show this option universally. In such cases, use Task Manager to end all running Microsoft Access processes and ensure no instances remain open
Method 6: Repair Corrupt Access Database
Database corruption can cause Access to mishandle its own file‑locking mechanism, resulting in the “file already in use” error even when no other user has the file open. In this case, you can use the Microsoft inbuilt utility – Compact and Repair to repair the corrupt database. Here’s how to use this tool:
- Open the Microsoft Access application.
- Double-click on Blank desktop database.
- Go to File > Close.
- On the Blank Database window, click File.
- Click Compact and Repair database, under Database Tools.
- Choose the database you need to Compact and Repair and click on Compact.
- Once the process is complete, a compacted and repaired copy of the Access database will be saved at the actual location where your database is stored.
If the Compact and Repair utility fails to fix the corrupted database then you can use a professional Access repair tool, such as Stellar Repair for Access. It is an advanced tool to repair corrupt MDB and ACCDB files. It recovers all the database objects, like forms, macros, tables, deleted records, modules, etc. The software allows you to preview the recoverable data before saving it. It is compatible with database files of MS Access 2019, 2016, 2013, and earlier versions.
How to Fix “Access Database in Use” Error Caused by Severe Corruption Using Stellar Repair for Access?
- Run the Stellar Repair for Access software. The software’s main interface with a ‘Select Database’ dialog box will open. Use the Browse option to select the corrupt Access database file and then click Repair to begin the repairing process.
Note: Use the Find button to find the file if you’re not aware of its location. The process of searching a database file across all the subfolders might take some time to complete.
- The corrupt Access database file is under repairing process. Recommended not to stop the process in-between.
- Hit the OK button when the ‘Repairing Complete’ message box pops up.
- All the repairable objects, such as tables, queries, forms, etc., will be displayed in a tree-view structure in the left pane. Expanding the objects will show all the repairable child objects.
- Now check the results in the preview, then click Save Database.
- Choose either a default location or a new folder to save the file.
- You will get the following message on completion of the repair process.
- Go to the location where the repaired Access database file is saved and start using it in your MS Access application.
Closure
The Access database error “file already in use” can occur due to numerous reasons, such as incorrect folder permissions, corrupted locking file, etc. You can follow the methods mentioned above to fix the error. If the corruption in .ACCDB/.MDB is behind it, then you can take the help of the built-in utility-Compact and Repair tool to repair it. If it fails, then you can use a professional Access database repair software, such as Stellar Repair for Access. It can easily repair highly corrupted MDB/ACCDB files of large size . Also, it can help you quickly recover database objects like macros, modules, forms, etc., with 100% integrity. You can even download the tool’s demo version of the software to evaluate its performance.
FAQs:
