Microsoft KB Archive/285356

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

Article ID: 285356

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.  Close, and then reopen 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. Click Page connection properties on the field list toolbar. 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 using the following format: <pre class="fixed_text">  \\servername\sharename\filename.mdb </li> Click OK twice to return to the data access page, and then save your changes.</li></ol>

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

Keywords: kbprb KB285356

-

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

© Microsoft Corporation. All rights reserved.