Sys Table for Pass-Through Query?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I'm trying to find the location where I can find the connection string
for a pass-through query. I know that I can find the connection string
for a linked table in the MSysObjects table, but this table doesn't
seem to contain the connection strings for pass-through queries.

Is there a place similar to the MSysObjects table that holds the
connection string for pass-through queries?

Thanks!
 
Thanks for the reponse, Arvin. That article shows how to create a
passthrough query, which I already have. What I need is a way to
retrieve the connection string for a number of passthrough queries in
a number of Access databases. Here's some further info on my situation
to help explain this.

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!
 
Back
Top