vb link table

[Jacco]

Hi everyone,

I want to link a single table from a another db into the current one with
the use of vb. After that I run queries on it to copy data, and the I want
to remove the link. Is this possible? The queries are not a problem (already
defined) but I can't seem to link.

Jacco

 

[Larry Daugherty]

Hi,

You can find some code on www.mvps.org/access that could help you do what
you want. But the big question would be: "What harm would there be in just
leaving the link in place"?

HTH

 

[Jacco]

Solution:

DoCmd.TransferDatabase acImport, "Microsoft Access", "Filename", acTable,
"tablename_source", "tablename_destination"

<<<<<here go my sql queries>>>>>>

DoCmd.DeleteObject acTable, "tablename_destination"