• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1750
  • Last Modified:

File Already in Use (Locked Access Backend)

I have a distributed front end and a centralized backend for an Access database.  However, when multiple users open the database, some get the file is already in use.  In the advanced settings,  I've put the backend as default shared mode and default record locking as no luck.  Help would be greatly appreciated.

3 Solutions
You must make sure that all users who open the database have read, write, and create rights for the folder in which the database is located.
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
and make sure you check both share level permissions and the directory permissions.

They need create and delete rights in addition to read and update because Access uses a lock file to control multi-user access.  The first user to open the database causes Access to create the lock file - .ldb or .laccdb.  And the last person to log out, causes Access to delete the lock file.  If the first user doesn't have create permission, Access can't create the lock file and so it will open the database in exclusive mode.  Subsequent people get logged in as read-only.  If the last person out doesn't have delete permission, the lock file isn't deleted.  Having the lock file remain can interfere with automated backups because it looks like the .mdb/.accdb is in use.
mattfmillerAuthor Commented:
Thank you for your help.  It was due to some incredible odd security permissions from IT.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now