Microsoft KB Archive/225979

= ACC2000: Data Access Pages Are Updateable When Database Is Opened Read-Only =

Article ID: 225979

Article Last Modified on 7/13/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225979



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

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



SYMPTOMS
When a database is opened read-only, changes made to a data access page can be saved.



CAUSE
Even though pages appear in the Database window when you click Pages under Objects, only a link to the actual HTML file is stored in the database, not the actual page.

Because the page is a physically separate file and is not saved as part of the database, changes to the a page can be saved.



MORE INFORMATION
When the database is opened read-only, you are not able to rename or delete existing links or create new links in the Database window.

Steps to Reproduce Behavior

 * 1) Open Microsoft Access and create a new database.
 * 2) In the Database window, click Pages under Objects, and then click New. In the New Data Access Page dialog box, click Design View, and then click OK.
 * 3) Type Title Text for the page title.
 * 4) On the File menu, click Save. In the File name box, type Test . Click Save.
 * 5) On the File menu, click Close to close the page.
 * 6) On the File menu, click Close to close the database.
 * 7) On the File menu, click Open. In the Open dialog box, select the database that you created in step 1. Click the arrow beside Open, and then click Open Read-Only. Click OK to the message that you will not be able to save changes.
 * 8) Select Test and click Open.

Note that the title of the page is Title Text.
 * 1) On the View menu, click Design View.
 * 2) Change the page title from Title Text to Updated Title Text.
 * 3) On the File menu, click Export. In the Save as type list, click Microsoft Access Data Access Page and then click Save. Click Yes when prompted to replace the existing file.
 * 4) On the File menu, click Close.
 * 5) While the Test page is selected, click Open.

Note the title of the page is now Updated Title Text.

