New user locks others out when open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

User has a very old database. Conversion to Access 2002 SP1 took place some
time ago and it has worked fine since that conversion. Problem started when
a new person (ABC) was added. When ABC is in the database, all other users
are locked out. If anyone else is in database, no one else is locked out.

I've been reading here about using a "Security Wizard" but I am not a
regular Access user and have not worked with it. Any tips I can give the
user on how to change the security level on the new person?
 
Brenda said:
User has a very old database. Conversion to Access 2002 SP1 took
place some time ago and it has worked fine since that conversion.
Problem started when a new person (ABC) was added. When ABC is in
the database, all other users are locked out. If anyone else is in
database, no one else is locked out.

I've been reading here about using a "Security Wizard" but I am not a
regular Access user and have not worked with it. Any tips I can give
the user on how to change the security level on the new person?
Click to expand...

They don't have adequate permissions to the folder where the file resides. They
are unable to create the LDB file when they open the MDB file and that LDB file
is required for multi-user access. Hence, they end up opening the file
exclusively.

Either that are they are opening the file exclusively because that is how they
have Access configured as the default file open mode.
 
Thanks for the quick post. The user says that person ABC is currently
writing to the database so we assume she has write permissions to this
folder. I'm not familiar with the "default file open mode" and neither is
the user I'm speaking with. Can you shed any info on where/how to check this?
 
I located the default mode in Help. The user confirms that ABC has a default
mode of Shared. I don't see anything else in Options that appears to point
toward this problem. Any other suggestions?
 
Brenda said:
Thanks for the quick post. The user says that person ABC is currently
writing to the database so we assume she has write permissions to this
folder. I'm not familiar with the "default file open mode" and
neither is the user I'm speaking with. Can you shed any info on
where/how to check this?
Click to expand...

Doesn't matter what they can do in the app. That only tells you what
permissions they have on the MDB file itself. They need the ability to create
new files in that folder as well. See if that user can create a new text file
in that folder for example and then delete it.

In your file - open dialog in Access you can open a file for shared access or
you can open it exclusively. There is a setting in options that determines what
the default is for that. You need to make sure it is set to shared.
 
It's a Windows permission problem. They need read/write/create/delete permission on the folder.

Although delete isn't absolutely necessary, it's recommended.
 
Back
Top