There's really no easy way to determine if the table was created as part of your database or imported. When you link to data, you can work with the data just as if it were a part of your current database. But you're really viewing the data in its original database. If you modify the data, you make those changes to the source data. To delete a linked table, simply select that table in the Database window and press the Delete button.
Wizards make importing and linking foreign data easy.
The TransferDatabase method Many developers probably perform the DAO solution of creating a tabledef object and then using that object's Connect property to import and link data. However, a lot of users don't work with DAO on a regular basis and the TransferDatabase method offers a simple alternative. We'll only discuss the import and linking functionality in this article. If you're familiar with the TransferDatabase macro action, then you already know quite a bit about the TransferDatabase method, which uses the form DoCmd. The arguments in brackets are optional.