ACC2000: Data Access Pages Are Updateable When Database Is Opened Read-Only (225979)



The information in this article applies to:

  • Microsoft Access 2000

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.
  9. On the View menu, click Design View.
  10. Change the page title from Title Text to Updated Title Text.
  11. 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.
  12. On the File menu, click Close.
  13. While the Test page is selected, click Open.

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

REFERENCES

For more information about data access pages, click Microsoft Access Help on the Help menu, type Data access pages: What they are and how they work in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbprb KB225979