How to change table links in MDB file using VB?

[Mathematician]

Hi all,

i have few tables in *.mdb that are linked to *.xls files. I want to change their path link using VB in MS Access.
Do you know how the change table properties to change their link to another path using VB code? (something like "Link Table Manager" but in VB code )

Thanks in advance,

Mathematician

 

[T.Smith]

A quick solution is to run this code from a command button on a form.

docmd.RunCommand acCmdLinkedTableManager