Delete the link to a linked table in an Access database

When you delete a linked table (linked table: A table stored in a file outside the open database from which Access can access records. You can add, delete, and edit records in a linked table, but you cannot change its structure.), you are deleting only the information that Microsoft Access uses to open the table, not the table itself. You can link to the same table again later.

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Tables under Objects, and then click the linked table.
  2. Press the DELETE key.

Microsoft Access deletes the link and removes the table's name from the list.

 
 
Applies to:
Access 2003