Microsoft KB Archive/225937

= ACC2000: Cannot Link to a Table in an Access Project (*.adp) =

Article ID: 225937

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225937



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

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you try to create a link to a table that is in a Microsoft Access project (*.adp), you may receive the following error message:

Link can only be created between Microsoft Access database files.



CAUSE
Access projects display tables that reside in either a SQL Server or the Microsoft Database Engine (MSDE). You cannot link these tables from an Access project file.



RESOLUTION
To link tables that are stored in either SQL Server or the MSDE, select ODBC Databases in the Files of Type box of the Link dialog box. Then you can use an existing DSN to connect directly to the SQL Server or MSDE. For an example of how to do so, follow these steps:
 * 1) Open the sample database Northwind.mdb.
 * 2) On the File menu, point to Get External Data, and then click Link Tables.
 * 3) In the Files of Type box, click ODBC Databases.
 * 4) Select an existing DSN or click New to create a DSN that points to the SQL Server or MSDE that contains your tables, and then click OK.

NOTE: The server may ask you to log on. If you do not know the UserID and Password, contact your System Administrator.
 * 1) In the Link Tables dialog box, select the table(s) that you want to link, and then click OK.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb.
 * 2) On the File menu, point to Get External Data, and then click Link Tables.
 * 3) In the Files of Type box, click Microsoft Access. Note that the .adp extension appears in this list.
 * 4) In the Link dialog box, select any .adp file from the file list.
 * 5) Click LINK.
 * 6) In the Link Tables dialog box, select any table in the Access project and click OK. Note that you receive the error message described in the "Symptoms" section of this article.

