Microsoft KB Archive/92644

From BetaArchive Wiki
Knowledge Base

ACC: Differences Between Native and Linked (Attached) Tables

Article ID: 92644

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q92644

Novice: Requires knowledge of the user interface on single-user computers.


Linked (attached) tables, such as Microsoft Access, Paradox, Btrieve, FoxPro, or dBASE tables, are different from native Microsoft Access tables in four ways:

  • In the Database window, the icons for linked tables contain black arrows.
  • If you try to open a linked table in Design view, you receive the following message.

    In Microsoft Access 7.0 and 97:

    Table 'xxxxx' is a linked table. Some properties can't be modified. Do you want to open it anyway?

    In Microsoft Access 1.x and 2.0:

    Table 'xxxxx' is an attached table. Some properties can't be modified. Open it anyway?"

  • When you delete a linked table, its contents are not deleted. Only the table entry is deleted.
  • You can define relationships between linked tables and native Microsoft Access tables, or between linked non-Microsoft Access tables and native Microsoft Access tables, but you cannot enforce such relationships.

    You can create relationships between a linked Microsoft Access table and a native Microsoft Access table.


For more information about linking external tables, search for "importing data," and then "Import or link data" using the the Microsoft Access Help Index.

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Keywords: kb3rdparty kbinfo kbinterop KB92644