cannot lock file

[linda]

We have a database that several people are trying to
access at once. They keep getting a message "cannot lock
file".

 

['69 Camaro]

Hi, Linda.

In a multiuser Access database, all users must have "Full Control" Windows
security permissions. The users who receive this error message don't have
this. Have your Windows network administrator grant these permissions to
all of the database users.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jon]

Check the security on the folder containing the data file. I've seen this
same thing when users have been granted read only access.

Jon

 

[Van T. Dinh]

Make sure they all open the database in "Shared" mode and not "Exclusive".

OTOH, for a multi-user database, you should split the database into
Front-End and Back-End. See Access Help on splitting a database.