Linking tables programatically

[audreybmorin]

Hi,
I can link tables programatically, but, of course, every time I do this, a new link is added instead of just updating the link.
I have a function that can retrieve the current link (not updated).
I can then compare this to the valid link (value to which the table link must be updated).
All I need to do now is update the link if it is invalid the current and valid links are not the same.
What function/method/etc. should I use to update the link?
Thanks.

 

[Marshall Barton]

I can link tables programatically, but, of course, every time I do this, a new link is added instead of just updating the link.
I have a function that can retrieve the current link (not updated).
I can then compare this to the valid link (value to which the table link must be updated).
All I need to do now is update the link if it is invalid the current and valid links are not the same.
What function/method/etc. should I use to update the link?

Use the TableDef object's Connect property and RefreshLink
method.

 

[Chris Nebinger]

http://www.mvps.org/access/tables/tbl0009.htm

Set the tdf.Connect to a valid database file..

tdf.Connect = ";DATABASE=" & strPath
tdf.RefreshLink


Chris Nebinger

-----Original Message-----

every time I do this, a new link is added instead of just
updating the link.

Just the one I find so confusing

Could you please tell me how exactly to write this? I've

tried a couple of things and it's not working...