Access Right Problem

[Danny]

Dear all,

I have a access database was put on the server. And Some people have read-write access while some people only have read access. And the access right was define from the server. The problem is once those peoples have read and write open the database first, those people have only read access cannot open the file and the error message is "Can not lock file". Please Help! Thanks for your sugguestion.

Danny

 

[Douglas J. Steele]

All users need read, write and delete permissions to the folder where the
MDB file is located, even if they only need Read access to the file itself.
That's because Access creates a locking file (.LDB) in the same folder when
the first user opens the database. Subsequent users update that locking
file, and the last user out of the database deletes it.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Dear all,

I have a access database was put on the server. And Some people have

read-write access while some people only have read access. And the access
right was define from the server. The problem is once those peoples have
read and write open the database first, those people have only read access
cannot open the file and the error message is "Can not lock file". Please
Help! Thanks for your sugguestion.