Dbase locking others out

6 Apr 2005 6:19 PM

Erik Sparks

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?

6 Apr 2005 7:24 PM

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

Show quote

"Erik Sparks" <ErikSpa***@discussions.microsoft.com> wrote in message
news:DEAB46C7-82BD-45A0-9A35-2F32A90C17EC@microsoft.com...
> 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?

6 Apr 2005 7:33 PM

Erik Sparks

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.

Show quote

"Lynn Trapp" wrote:

> 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
>
>
> "Erik Sparks" <ErikSpa***@discussions.microsoft.com> wrote in message
> news:DEAB46C7-82BD-45A0-9A35-2F32A90C17EC@microsoft.com...
> > 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?
>
>
>