Access locking for certain users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joel Roland - 28 Apr 2004 17:50 GMT

I'm running access 2002 on my network with multiple
users.

Every time user A access the database no one else can get
in.

If any other user accesses the database anyone can get in
including user A.

If everyone exits the data base and user A logs back in
first no one else can access the database.

I've checked on user A's machine and in options/advanced
it is set to mode SHARE.

Any ideas?

Reply to this Message

Joan Wild - 28 Apr 2004 19:59 GMT

> I'm running access 2002 on my network with multiple
> users.
>
> Every time user A access the database no one else can get
> in.

Check the windows permissions on the folder. All users need read, write,
create, delete permissions on the folder. If the first person in doesn't
have create permissions, they can't create the associated ldb file, and the
mdb will be opened exclusively.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message