ADO ODBC CONNECTION STRING

From: John Lanford (lanfojo_at_tulsaschools.org)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 11:41:07 -0800

I have an access data base (mdb) with linked tables from an Ms sql database.
I am trying to use ADO in VBA to list the odbc connection string for each linked (pass through) table.
I have some code using DAO that can do this using the "connect" property of a tabledef object. But
I can't find the equivalent of this in ADO. I have used a catalog object to retrieve the names of all the
pass-through tables but I can't find the connection string. I use linked tables from 2 different sql databases
and I want to find the name of the database where the table is, I am trying to write a procedure to relink
the tables. I can work around this using the DAO properties. But I am trying to use ADO instead of DAO
whenever I can.

Thanks
John Lanford Tulsa Public Schools

Relevant Pages