User Profile
PeteHadden
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Database no longer shareable
George_Hepworth Thank you George - I spent a good few hours chasing my tail trying to get to the bottom of that one. It was so recent that there wasn't really anything on the general internet that helped. I followed the instructions from MS on rolling back to an earlier version of office: https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841 I settled on version 2111, build 1407.20226 and this works fine. I'm so glad I've only got about 6 PCs to do and not 60! How will we know when MS have released a fix I wonder? Thanks again - I'm buying you a virtual beer!17KViews0likes1CommentDatabase 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
Recent Blog Articles
No content to show