Change Table Links in VB

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I want to provide users of my application an option to select a 'Test'
database vs. a 'Prod' database, for training, etc.

I am assuming the best way to do this is to prompt the user for the
environment choice, then iterating through the table collection and
automatically changing the links, just as one would do manually via the
Tools | Database Utilities | Linked Table Manager. Does anyone already have
a procedure to do this that they are willing to share?

If there's a better suggestion/idea than this, please don't hesitate to
offer it up! :)

Chris
 
Back
Top