Automatically delete link between databases

[Tara]

I am working with two very simple databases. I have
created a macro in the first one that links a table in
the second one and then appends that data into a table.
The transfer itself works fine, but I'm not sure how to
then delete the link to the external table. Every time
the macro is run, a new link is created and I then end up
with multiple links to the same table. Any ideas?

Thanks!

 

[Steve Schapel]

Tara,

You forgot to mention how you are establishing the link in the first
place, and how you are transferring the data. But you should be able to
use a TransferDatabase macro to import your data without the need to
link tables.

 

[Jim/Chris]

Once you have established the link why break it? Why do
you have to link it again?

Jim

 

[Steve Schapel]

Agreed!