error 3734 in access 2002

  • Thread starter Thread starter PaulD
  • Start date Start date
P

PaulD

I am seeing the following symptom.
Open a database
open a form in design view
switch back to form view without changing anything
another user cannot open the database and receives the
following message:
"The database has been placed in a state by
user 'admin'on machine 'machine name'that prevents it
from being opened or locked."

The database is open in shared mode, using all defaults.
Any information on this would be helpful.
 
Making design changes requires that the database be in exclusive mode.
Therefore, opening a Form in Design view forces the db into exclusive mode.
Whether changes are subsequently made is irrelevant. The db will remain in
exclusive mode until that user closes the db.

The reverse of this is also true: if multiple users have a db open in Shared
mode, and you then attempt to make design changes you will get warnings that
you *may* not be able to save changes. This is because, since it can't set
the db to Exclusive with multiple users already logged in, there are no
guarantees that it will be able to save whatever objects you may change.
 
Back
Top