Automatically delete link between databases

  • Thread starter Thread starter Tara
  • Start date Start date
T

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!
 
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.
 
Once you have established the link why break it? Why do
you have to link it again?

Jim
 
Back
Top