Database not opening

[jj1]

I have my database placed on drive and people are not able to open the database. Its giving error




could not use 'G:\FileFrontend.accdb'; file already in use


I checked with IT and it shows everybody have modify access.


Please help immediately as I have 200 people waiting for me to make database working

[Bob Fitz]

A db that needs to be accessed by multiple users should be split with a single back end file, with each user having their own copy of the front end on their own machine. Each front end would then be linked to the tables in the back end. If you have 200 users you may need to change the back end file to an SQL Server type file.

[jj1]

I already have a spilt file and as you mentioned still it gives the same error

[Bob Fitz]

I already have a spilt file and as you mentioned still it gives the same error

Does each user have a copy of the front end on their own machine which has then been linked to the back end

[jj1]

Yes everybody has their own front end copy

[June7]

So each user has a G: drive on their local PC hard drive and the copy is saved there? Review https://www.accessforums.net/forms/u...-fe-46293.html

If G: drive is actually on the server then everyone is trying to open the SAME COPY.

[John_G]

I checked with IT and it shows everybody have modify access.

They need more than that - they need write and delete access to the drive as well, so that the lock file (.ldb in A2003) can be created, and deleted when the last user closes the backend database.

John