Dbase locking others out

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

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?
 
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.
 
Back
Top