Microsoft KB Archive/92644

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


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?"

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


REFERENCES

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