What is the difference between an “attached” table and a “linked” table?
Terminology Change Alert: In Microsoft Access 95 and later the term “attached” table was replaced with the synonymous term “linked” table. This new term can be misleading because essentially the behavior has not changed, and a linked table is not a linked object in OLE terminology. It is still just a string reference of the disk address to the database that contains the base table (if you look in the table properties you will see the hard-wired connection string). Linked tables in Microsoft Access bear no relation to OLE links found in Microsoft Word or Microsoft Excel; any similarity is in terminology only-they do not update automatically. If you move the location of the table or database, you will break the link. For the purposes of this document the terms are interchangeable, and the term, “base table,” is used to refer to the table that is being linked to or attached. Microsoft Access 95/97/2000 linked tables: The following changes in behavior have occurred. • Permissions are no lo
