Microsoft KB Archive/216945

= ACC2000: Link Dialog Box Incorrectly Lists ADP in Files Of Type =

Article ID: 216945

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q216945





Moderate: Requires basic macro, coding, and interoperability skills.

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



SYMPTOMS
The Link dialog box incorrectly shows the extension for Microsoft Access projects.



CAUSE
In the Link dialog box, the default Files of Type setting for Access includes the extension, "*.adp."



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior
 Locate or create an Access project file (*.adp) that has a valid connection to a SQL Server database. Close the project. Create a new Access database (*.mdb). On the File menu, point to Get External Data, and then click Link Tables. Under Files of Type, select Microsoft Access. Note that "*.adp" is included in the Access extensions. Select the Access project file located in Step 1 and click Link.</li> Select any table from the Link Table dialog box and click OK.

Note that you receive the following error message:

Links can only be created between Microsoft Access database files.

</li></ol>

Additional query words: pra

Keywords: kbbug kbfix KB216945

-

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

© Microsoft Corporation. All rights reserved.