You may receive an error message when you try to open a data access page in Access 2002 (839781)


The information in this article applies to:

  • Microsoft Access 2002


This article applies only to a Microsoft Access database (.mdb).

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

SYMPTOMS

When you try to open a data access page in Design view in a Microsoft Access 2002 database, you may receive the following error message:
Microsoft Access is unable to load the database schema. Save has been disabled. Either repair or reinstall Microsoft Office XP.

Additionally, when you try to open the data access page in Page view, you may receive the following error message:
An error occurred trying to use "<table name>". Check to see that the object exists.

This problem occurs when any of the following conditions are true:
  • The problem data access page retrieves data from an Access database, and the connection string of the data access page uses a Uniform Naming Convention (UNC) path of the database.
  • The problem data access page retrieves data from an SQL Server database.
  • You did not open a data access page that has an absolute path of the database in the connection string before you opened the problem data access page.
  • You have Microsoft Internet Explorer 6.0 Service Pack 1 (version 6.0.2800.1106) installed on your computer.

WORKAROUND

Before you open the problem data access page, you must open a data access page that has an absolute path of the database in the connection string.

You can also modify the connection string of the problem data access page so that the connection string of the problem data access page uses an absolute path of the database. To do this, follow these steps.

Note This method is only applicable when the problem data access page retrieves data from an Access 2002 database.
  1. Start Access 2002.
  2. Exclusively open your Access 2002 database that has the problem data access page.
  3. In the Database window, click Pages under the Objects section.
  4. In the right pane, right-click the problem data access page, and then click Design View.

    Note You may receive the error message that is mentioned in the "Symptoms" section.
  5. Click OK if you receive the error message.
  6. On the Edit menu, click Select Page.
  7. In the Page : <Name of the data access page> dialog box, modify the connection string on the Data tab so that the connection string of the data access page uses an absolute path of the database.

    For example, the connection string of the data access page may be similar to the following:

    Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\<server name>\Samples\Northwind.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet

    Modify the previous connection string so that the connection string looks the same as the following connection string:

    Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source="C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb";Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet
  8. Save the data access page, and then close the data access page.
  9. Close Access 2002.

MORE INFORMATION

When you try to open a data access page in an Access 2002 database, and that data access page tries to retrieve data from an SQL Server database, you may receive the following error message:
The dynamic link library MSVCR70.dll could not be found in the specified path <Path>
After you receive the previous error message, you may next receive the error message that is mentioned in the "Symptoms" section.

Steps to reproduce the problem

Note Before you start the following steps, share the parent folder of the sample database Northwind.mdb. By default, the sample database Nothwind.mdb is in the following folder:

C:\Program Files\Microsoft Office\Office10\Samples

Caution If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
  1. Start Access 2002.
  2. Exclusively open the sample database Northwind.mdb.
  3. In the Database window, click Pages under Objects.
  4. In the right pane, double-click Create data access page by using wizard.
  5. In the Page Wizard dialog box, click Table: Products in the Tables/Queries list.
  6. Click >> to move all fields from the Available Fields list to the Selected Fields list.
  7. Click Finish.
  8. On the Edit menu, click Select Page.
  9. In the Data Link Properties dialog box, modify the connection string on the Data tab so that the Connection String property of the data access page uses a UNC path of the database.
  10. Save the data access page, and then name the data access page TestDAP.htm.
  11. Close the data access page, and then close Access 2002.
  12. Start Access 2002.
  13. Open the sample database Northwind.mdb.
  14. In the Database window, click Pages under Objects.
  15. In the right pane, right-click TestDAP, and then click Design View.

    You may receive the following error message:
    Microsoft Access is unable to load the database schema. Save has been disabled. Either repair or reinstall Microsoft Office XP.
  16. Click OK if you receive the error message.
  17. On the View menu, click Page View.

    You may receive the following error message:
    An error occurred trying to use "Products". Check to see that the object exists.

REFERENCES

For additional information about the problem that occurs after you install Microsoft Internet Explorer 6.0 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

327952 Data access pages are empty after you install Internet Explorer 6.0 Service Pack 1 or Windows XP Service Pack 1

For additional information about the correct formats for a connection string, click the following article number to view the article in the Microsoft Knowledge Base:

304324 How to change the connection string for an Access 2002 data access page

Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kberrmsg kbDataBinding kbDatabase kbDAP kbprb KB839781 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.