Microsoft KB Archive/92644

= ACC: Differences Between Native and Linked (Attached) Tables =

Article ID: 92644

Article Last Modified on 1/18/2007

-

APPLIES TO


 * 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.



SUMMARY
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?&quot;

 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.

