Link to home
Start Free TrialLog in
Avatar of imaksu
imaksu

asked on

Could not lock file in Ms Access

Using Ms Access 2003 created an mdb file, put it on a folder on the server. When trying to open the mdb from a client who has full control authority to the shared folder we get "Could not lock file" Using Windows 2003 Server sw, Windows XP and Vista on clients.
ASKER CERTIFIED SOLUTION
Avatar of Sander Stad
Sander Stad
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott McDaniel (EE MVE )
Also make sure your permissions are inheritable by the files you place in this folder.

Also, you should provide for EVERY user a COPY of the database, and not allow them to share it. If you allow users to share, then one user can lock everyone out. IOW, split the database, place the Backend (Tables only) on the server, and deploy a FrontEnd (everything else) to each user.