ACC2002: Imported Data Access Page Retains Original Data Source (285356)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q285356
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.

For a Microsoft Access 2000 version of this article, see 202210.

SYMPTOMS

When you import a data access page from a Microsoft Access database or a Microsoft Access project (.mdb or .adp) into your current Access database or project, the ConnectionString property of the page still references the original source.

CAUSE

By design, Access does not change the ConnectionString property of the data access page during the import process. Access only stores links to data access pages; the HTML files are stored elsewhere, and are not physically stored in the database file. Data access pages can have a data source outside of the database that stores the link. Therefore, Access does not change the data source when you import the link into your database.

RESOLUTION

Manually change the ConnectionString property of the data access page.

MORE INFORMATION

How to Change the ConnectionString Property

After you import the data access page into the new database, follow these steps to change the ConnectionString property.
  1. Close, and then reopen the database.
  2. Open the data access page in Design view.
  3. If you do not see the field list, click Field List on the View menu.
  4. Click Page connection properties on the field list toolbar.
  5. In the Data Link Properties dialog box, click the All tab.
  6. Click Data Source, and then click Edit Value.
  7. In the Edit Property Value dialog box, change the Property Value to the path name that you need using the following format:
       \\servername\sharename\filename.mdb
  8. Click OK twice to return to the data access page, and then save your changes.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb KB285356
©2004 Microsoft Corporation. All rights reserved.