copying linked tables - Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to copy linked tables from the front end database, but when I copy
them or export them to another database, they copy across still as linked
tables. I want to copy the tables, but not take the link with them, or to
break the link. Is there any way to do this?
Thanks,
 
Think of it like this:

If you have a Word document on a server and a shortcut on your desktop, and
you copy the shortcut to a different computer, did you actually copy the word
document?

It is the same with linked tables. The linked table in the FE is a
"shortcut" to the actual table in the BE.

To copy the tables to another database, import (copy) the tables from the BE
mdb.


HTH

Steve
 
Back
Top