Problem Occurs When a Database Is Set Exclusively Opened or Locked When a Form References a Control on a Subform (247180)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q247180
This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you open a form in a Microsoft Access 2000 database, the database may be set to open exclusively if the following conditions are true:
  • A form that contains a subform is opened, and that form has a control that references a subform control.
  • A form is opened when only a single copy of the database is opened.
As a result, when another instance of Access 2000 tries to open the database, you may receive the following error message:

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

Note The run-time error is 3734

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

For additional information about Microsoft Office 2000 SR-1/SR-1a, click the following article number to view the article in the Microsoft Knowledge Base:

245025.KB.EN-US OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

WORKAROUND

To temporarily work around the problem, open one instance of the database that does not have the problem form open. Leave the database open at all times. If you open the problem form in the next instance of the database, the problem does not occur.

Note In this scenario, the second condition that is mentioned in the "Symptoms" section is violated.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Start Access 2000.
  2. Open the Northwind.mdb sample database.

    Important Do not open the database exclusively. Make sure that the database has not already been opened by you or by another user.
  3. In the Database window, click Forms under the Objects section.
  4. In the right pane, right-click the Orders form, and then click Open.
  5. With the Orders form still open, start a second instance of Access 2000.
  6. In the second instance of Access 2000, open the Northwind.mdb sample database again.

    Notice that when you try to open the Northwind sample database in the second instance of Access 2000, you receive the error message that is mentioned in the "Symptoms" section.

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

Modification Type:MinorLast Reviewed:9/26/2005
Keywords:kbHotfixServer kbQFE kbbug kbfix kbQFE KB247180 kbAudDeveloper