Multiple Users Split Database

[Fred]

I have a split database with user level security on our
network. Record locking is set to edited record. Each
user has downloaded the front end on their computer. The
problem is only one user at a time can open any given
form. What's up with that?

 

[Douglas J. Steele]

What permissions do they have on the folder where the back-end is located?
They need Change (Read, Write, eXecute, Delete). This is because a locking
file (.ldb) gets created in that folder when the first user attempts to use
the application. Subsequent users update that locking file, and the last
user to quit deletes it. It is not possible to have the locking file written
to a diferent folder.

 

[Fred]

It worked, Thank You. I thought I was being clever by
hiding the back end in a location users could not access.

 

[Joan Wild]

It worked, Thank You. I thought I was being clever by
hiding the back end in a location users could not access.

If you want to you can hide the share where the backend is

\\server\share$ rather than \\server\share.

That will hide it in Windows Explorer, but if users know the path, they can
get to it.