Microsoft KB Archive/202384

= ACC2000: You Cannot Create or Modify a Data Access Page When a Database Is Open in Read-Only Mode =

Article ID: 202384

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q202384



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
Even though a database stores only a link to a data access page and not the data access page itself, you still cannot create a new data access page in a database that you have open in Read-Only mode. You can also not save changes to an existing data access page in a database that you have open in Read-Only mode.



STATUS
This behavior is by design.



MORE INFORMATION
To create a new data access page or to modify an existing page, you must open a database in Shared mode or in Exclusive mode. If you open the database in Shared Read-Only mode or Exclusive Read-Only mode, you cannot create new data access pages or modify existing pages.

It is possible to use an HTML editor to modify the HTML file created in a non-read-only database outside of the read-only database. However, this practice is not supported by Microsoft Technical Support Professionals.

Steps to Reproduce the Behavior

 * 1) Start Microsoft Access. When you see the Microsoft Access dialog box, click Cancel.
 * 2) On the File menu, click Open. The Open dialog box appears.
 * 3) In the Look in list, browse to the folder where Northwind.mdb resides. This is typically C:\Program Files\Microsoft Office\Office\Samples.
 * 4) Click Northwind.mdb, click the arrow next to the Open button, and then click Open Read-Only.
 * 5) Click OK when you see the message explaining that Northwind.mdb is being opened read-only.
 * 6) Click Pages in the Database window and note that the New button is unavailable (is dimmed).
 * 7) Open any data access page in Design view and note that the Save button and the Save command on the File menu are dimmed.

Additional query words: inf prb

Keywords: kbdap kbprb KB202384

-

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

© Microsoft Corporation. All rights reserved.