Unlink a linked table?

[afs24]

I have a bunch of linked tables from our companys main database. I'm trying to keep the tables without linking them? I basically want the exact table or a copy that isn't linked. If I copy it it's still linked. How do I unlink? Thankyou.

 

[ebkid]

You could create make table queries for each of the tables. Delete the linked tables and rename. Bit of a pain if you have alot of tables.

ebkid

 

[SydneyGeek]

You could also export the tables out to another database that you keep as an archive. Also a pain if you have lots of tables but it can be automated using the point-and-click macros or (better) using VBA

HTH
Denis

 

[bat17]

Tools>Get External Data>Import.... Select the database with the original tables. Select the tables you want, and hit OK

Peter