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

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.