ACC2000: Imported Data Access Page Retains Original Data Source (202210)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202210
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 2002 version of this article, see 285356.

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

Changing 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 re-open 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. On the Database tab, right-click the top node in the list--the cylindrical icon that represents the data source to which your page is connected--and then click Connection.
  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 in the following manner:
       \\servername\sharename\filename.mdb
  8. Click OK two times to return to the data access page, and then save your changes.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbDAP kbprb KB202210
©2004 Microsoft Corporation. All rights reserved.