Other users can only open my db as read-only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 30 Sep 2004 22:29 GMT

Windows XP / Access 2002

When other users try to open a db I've created, they can only open it as a
read-only version and can not save edits to the db. I'm hoping someone can
suggest what might be causing this behavior and how to fix it. Thanks.

Bob

Reply to this Message

Douglas J. Steele - 30 Sep 2004 22:44 GMT

They must have Change permission (Read, Write, eXecute and Delete) on the
folder where the MDB exists.

This is because the first user into the database creates a locking file
(.ldb) in the folder, subsequent users update that file, and the last user
out of the database deletes it.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Windows XP / Access 2002
>
[quoted text clipped - 3 lines]
>
> Bob

Reply to this Message