cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to Resolve Access database error ‘file already in use’

I check my file, there is no corruption in the Access database file. What else I can do?

1 REPLY 1
Highlighted
New Member

Re: How to Resolve Access database error ‘file already in use’

If there is no corruption in database file it means the user does not have ‘create’ rights for the folder in which the database is present, and he opens the database. 

The MS Jet database engine does not create the locking information file LDB in Access 2003 and in earlier Access versions and LACCDB in MS Access 2007 and 2010 versions, which is essential for multiple users to open the database.

Note – A user who does not have ‘create’ rights needs to open the database entirely if an analogous LDB file or LACCDB file is not present.

For better understanding you may read this related blog, which also helps me to resolve this issue one month before- https://www.stellarinfo.com/blog/resolving-access-database-error-file-already-in-use/

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,977)