Unlinking tables from another database

[Ian Belcher]

I'm currently using Access 2002. I've linked a table from
another data base. My database has grown to more than it's
original plan and I need to change the linked table. My
first instinct was to replace it with a new table.
However this table appears in many queries and VB script
so this would be time consuming and may create errors. I
can't find a way to simply un-link the table and store it
in the current database.

I would appreciate any ideas as to how to get round this
problem. Thank you

Ian

 

[Allen Browne]

Are you sure you cannot simply open the remote mdb and modify the table
there?

If you want to continue with importing it instead of linking it:

1. On the Tables tab of the Database window, select the linked table. (It
will have an arrow like a shortcut to the table, not a local table).

2. Delete it. That removes the link.

3. From the File menu, choose Get External | Import.
Navigate to your database file, and select the table to import.