ACC2000: "The Database Has Been Placed in a State by User..." Error When You Open a Database Containing a Form That Has a Subform

ID: Q248967

The information in this article applies to:
  • Microsoft Access 2000
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS

When a form is open in a database, and if that form has a control on it that references a subform control, when you try to open a second instance of the database, you may receive the following error message:

The database has been placed in a state by user 'username' on machine 'machinename' that prevents it from being opened or locked.


CAUSE

This problem can occur when the following three conditions are true:

  • A form contains a subform.
  • A control on the main form references one of the controls on the subform.
  • The form is open in a single instance of the database.
If these conditions are true, and you then try to open a second instance of the database, you receive the error message described in the "Symptoms" section.


RESOLUTION

To work around this problem, leave one instance of the database that does not have the problem form open running at all times. In this way, there is never one copy of the database left open that has the problem form open.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.

    IMPORTANT: Do not open the database exclusively, and make sure the database has not already been opened by you or another user.


  2. Open the Orders form in Form view.


  3. With the Orders form still open, start a second instance of Access.


  4. In the second instance of Access, open the sample database Northwind.mdb again.


Note that you receive the error message mentioned in the "Symptoms" section.

NOTE: The problem occurs in this case because the Orders form contains a control that is named Subtotal, which refers to a control that is named OrderSubtotal in the subfrom as follows:
Control Source: =[Orders Subform].Form![OrderSubtotal]

Additional query words: pra admin

Keywords : kberrmsg kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: January 28, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.