Deleting Links to External Tables

You can also delete the TableDef object associated with an external table. This removes the table’s icon from your Microsoft Jet database along with the associated linking information. When you delete a TableDef object that defines a linked table from your Microsoft Jet database, the external table is unaffected. You use the Delete method of the TableDefs collection object to delete a table from a Microsoft Jet database. For example, the following code fragment deletes the LostLink table from the database:

dbs.TableDefs.Delete "LostLink"