How to Unlink an Access Table

Microsoft Access allows to link to outside tables. When the outside table is no longer needed, you may need to unlink the table in order for your database to run faster. Tables are often linked to import old data when a database is first created or during a database change or upgrade. Unlinking a table is an easy process. When you delete a linked table, you only delete the link, not the table itself. Any data currently stored in your table will remain.

Step

Open an existing Microsoft Access database with a linked table.

Step

Click “Tables” in the database window to display all tables and linked tables.

Step

Single-click the linked table. Linked tables have a small arrow at the beginning of the table name.

Step

Press “Delete” on your keyboard, or right-click the table and press “Delete.” This removes the linked table name from your “Tables” list. The original table, the now unlinked table, will remain.

Step

Go to “File" and choose "Save” to save the changes.