Pulling Connection Strings from Existing Passthrough Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for the easiest way to gather a list of connection string info
for passthrough queries in about 100 Access databases. Can someone give me a
suggestions on the best way to do this?

Here's my situation.

I have been assigned to support about 100+ MS Access databases. Some
of these connect to Oracle and SQL Server databases. I'm trying to
gather a list of these connections.

I've been able to collect the *linked table* information by connecting
to each database and pulling in info from the MSysObjects table. That
worked well, but does *not* show information about passthrough queries.
I cannot find a table that shows the connection string property for
the passthrough queries.

I've tried creating a workspace and pulling the data that way, but
it's very slow and problematic with the mdw security files.

Is there something like the MSysObjects table that would show the
connection string for a pass-through query?
Is there some better way to collect this information for a range of
access databases?

Thanks in advance!
 
If the connection string was saved with the query, then you can get at
it through a DAO QueryDef object. I think I remember it being the
..Connect property. Ditto for TableDef objects (if linked tables are
saved in the mdb).

-Mary
 
Back
Top