Microsoft KB Archive/248936

= ACC2000: Canceling Form or Report Wizard Does Not Release Exclusive Lock =

Article ID: 248936

Article Last Modified on 11/25/2002

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q248936



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you start the Form or Report Wizard in Microsoft Access 2000 to create a new form or report, and you then cancel the wizard, you may receive one of the following error messages if you try to open a second instance of the same database:

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

-or-

Could not use ; File already in use.

-or-

The database will be opened read-only because one of the following occurred: the file is locked for editing by another user, or the file (or folder in which it is located,) is marked as read-only, or you specified that you wanted to open this file read-only.



CAUSE
When the New Object dialog box or the Form or Report Wizard is cancelled, Access puts the opened database in exclusive mode. Canceling the request for a new form or new report should not create a dirty object, but it does. The exclusive lock should be released if there are no other dirty objects in the project, just as it is done when you close the last dirty form.



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

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

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



STATUS
Microsoft has confirmed that this is a problem in Access 2000. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.



Steps to Reproduce Behavior

 * 1) Open sample database Northwind.mdb.
 * 2) In the Database window, click Forms under Objects, and then click New.
 * 3) Click Cancel in the initial New Form dialog box.
 * 4) Start a new instance of Access 2000, and then try to open the same Northwind.mdb database.

Note that you receive one of the error messages mentioned in the "Symptoms" section.

NOTE: You can reproduce this same error by choosing a report instead of a form.

Additional query words: pra

Keywords: kbbug kbpending KB248936

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.