Microsoft KB Archive/248936

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 13:50, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Article ID: 248936

Article Last Modified on 11/25/2002


  • 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).


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 UserName on machine MachineName that prevents it from being opened or locked.


Could not use path\databasename; File already in use.


The database databasename 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.


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.


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)


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