New user locks others out when open

[Brenda from Michigan]

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 from Michigan]

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?

 

[Brenda from Michigan]

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?

 

[Rick Brandt]

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?

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.

 

[Joan Wild]

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.