Access locking for certain users

J

Joel Roland

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?
 
J

Joan Wild

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

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

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.
 
Top