Unlinking tables from another database

  • Thread starter Thread starter Ian Belcher
  • Start date Start date
I

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
 
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.
 
Back
Top