access lock share laccdb
1 Topic
Database no longer shareable
For years we've used a split front-end / back-end Access DB. Each PC has a copy of the client and the backend data lives on a NAS drive. For some reason recently, once one user opens their client, no other user can access theirs with the message "count not use \\nameofthebackendDB.accdb; file already in use" I've checked the users have read/write/create privileges (nothings changed anyway) - the first user causes a lock file .laccdb to get created with 0 bytes, and when they close Access the file remains in the backend folder. I even tried creating a new database with just a single table and a couple of clients to connect to it and the same thing happens. It also happens when I store the backend on different devices such as a shared folder on a PC. Has something happened to Access or Windows that would cause this behaviour?Solved17KViews0likes17Comments