User unable to create a locking file

[Prime76]

Hi,

I currently use a Front-end/Back-end access 2003 database (windows xp pro). On of its users tried to login but received the error message that they were unable to create a locking file. There were two users already logged in (both with admin credentials) but when i tried to login (admin as well) it opened up fine for me. Is this due to something in the code that may be a certain amount or certain type of user? Thanks for your help.

 

[KernelK]

I ran into this issue a while back. The solution for me had to do with User permissions for the directory where the DB was housed. The user encountering the problem did not have write or delete access to files in the directory. So when access tried to create the locking file, the user was denied because of windows permissions. Compare your windows permissions in that directory to the user having the problem.

 

[The_Doc_Man]

In simple permissions, you need MODIFY access to the folder.

In the long-form permissions (detailed permissions), you need everything EXCEPT change-owner, change-protection, and a couple of other admin-only permissions. You need to be able to create, read, update, or delete files. You ALSO need pass-through on all parent folders above the one holding the database. If the database uses files in sub-folders of its own location, you want your rights to propagate downwards (away from the root of the directory tree).

 

[Prime76]

Thanks guys...I'll check into the permissions!