Can I use ADO to dynamically link tables?

[Guest]

I have the code to dynamically link tables using DAO, but can't find a way to
do this using ADO.

 

[Brendan Reynolds]

You need to use ADOX for that. There's example code at the following URL ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;291264

 

[David C. Holley]

Define 'dynamically link'? Do you mean that you have a *.mdb file that
has links to another *.mdb file and you want to update the links?

 

[Guest]

Thanks. Works like a charm.

You need to use ADOX for that. There's example code at the following URL ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;291264

 

[Guest]

Brendan's suggestion to use ADOX worked perfectly. I have an application .mdb
file and a data .mdb file. When I send a new copy of the appl to users I need
the links to the data .mdb file refreshed.