Datbase locks up

[Guest]

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.

 

[Guest]

Hi.

I have a shared database that is split into a back end and shared front end.

You missed a step. No one should be sharing the front end. Distribute a
copy of the front end to each user, so each can save it to his workstation's
hard drive.

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.

Locks up the database as in "an hourglass appears and we wait while the
Jeopardy theme song plays, but the the database never opens"? Or locks up
the database as in the database refuses to open because "The database has
been opened exclusively or you do not have permission to open it. Please see
your Adminstrator"?

HTH.
Gunny

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

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Guest]

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

 

['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"

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.

 

[Albert D.Kallal]

With different versions, you MUST split your database, and place a copy on
EACH computer.

Please read the following article that explains why you must do this:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[Guest]

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