Change Link in Multiple Tbl

B

briank

My db has a few dozen linked tables from an outside Access db. I would like
to change the links in all of theses tables to another source. It appears
that the only way to do this in Access is one table at a time. Is there a
way to do this in mass?
 
K

Klatuu

You can do this with either a macro or in VBA.
Use the DeleteObject method for each existing table.
Use the TransferDatabase method to link to the new tables.
 
Top