Datbase locks up

C

Cyberwolf

I have a shared database that is split into a back end and shared front end.
Every once in a while a user will open the front end and it locks up the
database so no one else can get in.

Is there a way to prevent this from happening. We are running ACcess 200
and 2003 in multiple Window environments from 98 to XP Pro.
 
C

Cyberwolf

Locks up as in "The database has been opened exclusively or you do not have
permission to open it. Please see your Adminstrator"
 
6

'69 Camaro

Hi.
Locks up as in "The database has been opened exclusively or you do not
have
permission to open it. Please see your Adminstrator"
Click to expand...

A number of things can cause this:

1.) The most likely cause is that the database is using Jet 4.0 with a
shared front end file, only one user has the file open and that single user
makes a change to a database object or creates a new database object, which
elevates the mode to "exclusive." Until that change or new object is saved,
the file will remain in exclusive mode (even if the user originally opened
it in shared mode), and no one else will be able to open it. The solution
to this problem is to distribute a copy of the front end to each user so
that no one is sharing that file when it needs to be elevated to exclusive
mode.

2.) One of the users is unknowingly opening the front end in exclusive
mode. Check each user's "Default open mode" setting. Each user must open
the Tools -> Options... menu to open the Options dialog window, then select
the Advanced tab and ensure that the "Shared" option under "Default open
mode" is selected. (But it's better to just distribute the front end to
each user.)

3.) User-level security has been applied and the user doesn't have "Open
Database" permission. (If you haven't applied user-level security, then you
can rule this out. If you've applied user-level security, you can rule this
out if this user can open the database at other times while joined to the
secure workgroup.)

4.) The database file is corrupt. (Make sure that back ups are made
_before_ the database bites the dust.)

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
 
D

Dgem601

As a novice user to Access, how do you just give the "front end" to users? I
have about 30 users for one DB and the way it is now -only one of them can
open it at a time. Need for all of them to be able to use at the same time,
if needed. Thanks
 
Top