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

ID: Q216945


The information in this article applies to:

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 this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Locate or create an Access project file (*.adp) that has a valid connection to a SQL Server database. Close the project.


  2. Create a new Access database (*.mdb).


  3. On the File menu, point to Get External Data, and then click Link Tables.


  4. Under Files of Type, select Microsoft Access. Note that "*.adp" is included in the Access extensions.


  5. Select the Access project file located in Step 1 and click Link.


  6. Select any table from the Link Table dialog box and click OK.

    Note that you receive the following error message:


  7. Links can only be created between Microsoft Access database files.

Additional query words: pra


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: May 13, 1999