Re-link to another DB from code

[Bill]

How does one re-link, in code, all of its currently
linked tables to a different backend from the current
frontend mdb . Like one would do with the
"Linked Table Manager".

Thanks,
Bill

 

[Marshall Barton]

How does one re-link, in code, all of its currently
linked tables to a different backend from the current
frontend mdb . Like one would do with the
"Linked Table Manager".

Here are some examples that do that:
http://dfenton.com/DFA/download/Access/Reconnect.html
http://www.mvps.org/access/tables/tbl0009.htm
http://www.mvps.org/access/tables/tbl0012.htm
http://www.mvps.org/access/tables/tbl0010.htm

 

[Bill]

Thanks Marsh,
I think I can sort out the issue here from
what others have done.
Bill