Multi user access

[sharon attwood]

I created a database which will need to allow many users at once. A group of us can access the file at the same time, but 1 new user cannot. If anyone has the file open she gets the message "Could not lock file", if she has the database open first we get the message "could not use (file name) file already in use".

I have checked the access rights etc and cannot find any difference between hers and the rest, can someone please help

Many thanks

Sharon

 

[The_Doc_Man]

First guess: Verify that your problem user has joined the correct workgroup. This sounds like an "exclusive open" problem and that occurs most often when the problem users are running as SYSTEM. This in turn occurs most often if they have not joined the workgroup for the DB, but instead are still members of the default workgroup created when you first install Access. In the default workgroup, the owner (primary user) of the workstation appears to be user SYSTEM.

 

[MStef]

Hello Sharon!
Check and adapt
"Default open mode",
"Default record locking"
in Tools - Options - Advanced.

 

[Pat Hartman]

This is a network permissions issue. It is not an Access security issue. Access uses the .ldb file to manage multiple user access. If the first person to open the db does not have permission to create this file, Jet will open the file in exclusive mode to block other users.

 

[sharon attwood]

Thanks you all very much

I tried the first 2 and everything seems to be OK

I have passed it on to our IT department as I know nothing about networks and so would not know where to start.

If they don't either - I might be back!

Thanks again

Sharon

 

[sharon attwood]

It worked

Thank you very much

Sharon