.IDB Creating

[adams.bria]

So I have split my database, and have a couple of front-ends accessing the back. The problem is that when one of the front-ends is opened it is creating a lock file, preventing it from being opened again. The front-end can still be accessed if I open access and open it from there, however, I cannot just click on the front-end in the folder structure to open it. Any ideas?

 

[Beetle]

Does each user have their own local copy of the front end, or are multiple users sharing the same file?

If the former, then check the users permissions for the network folder where the backend file is. Each user should have read, write, create, delete permissions. The lock file is a normal part of the process, but it should be deleted when the last user closes out of the application. If a user doesn't have delete permissions the lock file may not get deleted.

If the latter (multiple users sharing one file) then you should correct that by giving each user their own local copy of the front end.