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

This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

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

Symptoms
After you install Microsoft Internet Explorer 6.0 Service Pack 1 (SP1) or Microsoft Windows XP Service Pack 1 (SP1), some data access pages do not display data when the page is opened in Page view in Microsoft Access. When you open a data access page in Design view, you receive the following error message:
Cannot find the database or some database objects that this page refers to. Update the connection information of the page, or fix the references to the missing database objects.
Cause
This behavior occurs if the page contains a relative path to the database, and you have installed either Internet Explorer 6.0 SP1 or Windows XP SP1. Because of security changes in Internet Explorer 6.0 SP1 you can no longer use a relative path to the database.

Note The pages in the Northwind sample database each contain a relative path to the database, and therefore exhibit the behavior that is described in the "Symptoms" section of this article.
Resolution
Change the connection string to use an absolute or a universal naming convention (UNC) path to the database. For example, instead of using Northwind.mdb, use either of the following:
\\servername\sharename\Northwind.mdb

-or-
c:\program files\microsoft office\office10\samples\northwind.mdb
To modify the connection string for the page, follow these steps:
  1. Open the page in Design view.
  2. Click OK in response to the initial message.
  3. Right-click the page and then click Page Properties.
  4. Click the Data tab, right-click the ConnectionString property, and then click Build.
  5. Click the Connection tab, modify the path to the database under the Connection tab, and then click OK.
  6. Save the page.
More information

Steps to reproduce the behavior

  1. Install Windows XP SP1.
  2. Open the Northwind sample database.
  3. Open the Analyze Sales data access page in Page view.

    Notice that the page displays no data.
  4. Open the page in Design View.

    Notice that the error message that is mentioned in the "Symptoms" section appears.
pra prb
Properties

Article ID: 327952 - Last Review: 01/10/2015 13:43:59 - Revision: 5.0

  • Microsoft Access 2002 Standard Edition
  • kbnosurvey kbarchive kbtshoot kberrmsg kbpending kbprb KB327952
Feedback