Remove table link

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

Hello

I have imported an Access 2000 linked table into a
2002 Access file. How to we remove the link so we can
modify this table?

Thank you so very much.
 
Hello

I have imported an Access 2000 linked table into a
2002 Access file. How to we remove the link so we can
modify this table?

Thank you so very much.
Click to expand...

You don't need to remove the link in order to modify the table. Simply
open the database in which the table resides, make the modifications
there, and the linked table will continue to point to the modified
"real" table.

To remove a linked table from a database, simply select the table in
the Tables window and delete it. This just deletes the link, not the
data in the table.
 
-----Original Message-----


You don't need to remove the link in order to modify the table. Simply
open the database in which the table resides, make the modifications
there, and the linked table will continue to point to the modified
"real" table.

To remove a linked table from a database, simply select the table in
the Tables window and delete it. This just deletes the link, not the
data in the table.


.
Click to expand...

In my case the table also is deleted in the new database
and notjust unlinked. Any ideas why?
 
In my case the table also is deleted in the new database
and notjust unlinked. Any ideas why?
Click to expand...

Was the actual data table deleted from the backend database? What
databases are involved, and what operations did you actually perform?
If the database was deleted, it's GONE and you'll need to restore it
from the backup; if you just have a missing link to an existing
backend table, you can use File... Get External Data... Link to
establish a link (you don't need the database splitter wizard).
 
Back
Top