Access Right Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!)


Danny said:
Dear all,

I have a access database was put on the server. And Some people have
Click to expand...
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.
 
Back
Top