Microsoft KB Archive/839781

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

Article ID: 839781

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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 &quot; &quot;. 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 &quot;Symptoms&quot; section.
 * 1) Click OK if you receive the error message.
 * 2) On the Edit menu, click Select Page.
 * 3) In the 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=\\ \Samples\Northwind.mdb;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;;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=&quot;C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb&quot;;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;;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
 * 1) Save the data access page, and then close the data access page.
 * 2) 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 

After you receive the previous error message, you may next receive the error message that is mentioned in the &quot;Symptoms&quot; 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.  Start Access 2002. Exclusively open the sample database Northwind.mdb. In the Database window, click Pages under Objects. In the right pane, double-click Create data access page by using wizard. In the Page Wizard dialog box, click Table: Products in the Tables/Queries list.</li> Click >> to move all fields from the Available Fields list to the Selected Fields list.</li> Click Finish.</li> On the Edit menu, click Select Page.</li> 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.</li> Save the data access page, and then name the data access page TestDAP.htm.</li> Close the data access page, and then close Access 2002.</li> Start Access 2002.</li> Open the sample database Northwind.mdb.</li> In the Database window, click Pages under Objects.</li> 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.

</li> Click OK if you receive the error message.</li> On the View menu, click Page View.

You may receive the following error message:

An error occurred trying to use &quot;Products&quot;. Check to see that the object exists.

</li></ol>

<div class="references_section">