Cannot open .mdb file after users moved to active directory

  • Thread starter Thread starter Steven Wong
  • Start date Start date
S

Steven Wong

Hi:

I have an MS Access 97 application (.mdb) file residing on
a shared file server with 3 users. Everything has been
fine until the users performed an active directory
migration where the domain they used to sign on into their
PC had changed to a new one. When each one of them try to
open this file (not simultaneously), they were getting a
message saying that "another user had open the file
exclusively".

The only security build into this .mdb file (includes both
front-end and back-end) is a database password to get into
it. There is no workgroup or specific user setup for
accesses.

Could someone please shed some light as to why this might
be happening? We have double check to make sure that no
one else is accessing at the time the error occured.

Thanks in advance.
 
Each user needs to have Change access (RWXD) to the folder where the MDB
file exists. Might that have got impacted by the move to AD?
 
Doug:

Do you mean each of the user's permission to that folder?
Could you please elaborate on RWXD...I apologize for I am
not familiar with that acronym.

Thanks again.
 
Each user must have Read, Write, eXecute and Delete permission on the
folder. This is because the first user to open the database will create the
locking file (.LDB) in the folder, subsequent users will update that locking
file, and the last user to close the database will delete the locking file.
 
Back
Top