Link tables with VBA 1

[jpl458]

Is there a wqay to establish link tables with VBA, that is. get to the link table manager with code. I have an application that is linked to SQL Server, and another that is linked to a non-microsoft database. The linking for both is the same procedure. I now have a need for an application to be able to swith back and forth between the two databses, and I was wondering if there was a way to that in VBA. It sure would make life easier.

Thanks in advance

jpl

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jpl458]

This looks good. I will gie it a go this week, solves a big problem. Thanks so much

jpl