Access 2002

[Brian]

I have a user that cannot open an access .MDB if someone else is already in it.
If the user opens it first everyone else can open it.
So I need to have everyone get out then I have her open it and then everyone
else gets back in.

Brian

 

[Joan Wild]

Sounds like that user has the correct permissions on the folder where the
mdb is located, but everyone else does not.

All users of the mdb need read, write, create, delete permissions on the
folder. This ensures that they can create/delete the associated ldb file.
Without the create permission, the first person in opens it exclusively
because the ldb can't be created.