Change Link in Multiple Tbl

  • Thread starter Thread starter briank
  • Start date Start date
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?
 
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.
 
Back
Top