Copy linked table loses link

B

Bob T Bunny

Since upgrading to Office 2003, whenever I copy a linked table from
one database to another, it copies the original table into the new
database, not the link. Office 2000 always used to create a linked
table at the destination. Does anyone know of a way to paste the link
again, rather than the whole table? I really want to do this in VBA,
so if anyone can give me pointers, I would be greatful.

Thanks,

Bob
 
Top