Microsoft KB Archive/202210

= ACC2000: Imported Data Access Page Retains Original Data Source =

Article ID: 202210

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



Changing the ConnectionString Property
After you import the data access page into the new database, follow these steps to change the ConnectionString property.  Close, and then re-open the database. Open the data access page in Design view. If you do not see the field list, click Field List on the View menu. 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. In the Data Link Properties dialog box, click the All tab.</li> Click Data Source, and then click Edit Value.</li>  In the Edit Property Value dialog box, change the Property Value to the path name that you need in the following manner: <pre class="fixed_text">  \\servername\sharename\filename.mdb </li> Click OK two times to return to the data access page, and then save your changes.</li></ol>

Additional query words: OFF2000 dap prb old former same as it was didn't change did not changed

Keywords: kbdap kbprb KB202210

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.