Dbase locking others out

[Guest]

I've created a database that is supposed to let many users in at the same
time. I've created user accounts and made sure that they are not allowed to
get exclusive access to the database. The problem is that whenever I have a
user get into one of the forms, it locks everyone else out of the database.
Anyone else that tries to get in get a message saying "The Microsoft Jet
database engine cannot open the file''. It is already opened exclusively by
another user, or you need permission to view its data."

Once the other user exits the current user has not problem entering (except
that user now locks everyone out), so I know it's not a problem with
permissions. I made sure that in the Options I have the default set to open
Shared. I'm sure I'm missing something silly, can anyone help me out?

 

[Lynn Trapp]

Erik,
The most common cause of that problem has to do with permissions on the
Folder the database is stored in. All users need to have Read, Write, and
Delete permissions on that folder.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Guest]

I just discovered my problem. One of my tables was linked to an external
..txt file. I guess only one person at a time can access a text file. I
converted it to an table in and external dbase and it worked fine. Thanks
for your help.