Pass-Through Query / Multiple ODBC Connections

When creating a Pass-Through Query, is there a way to create two or more
“ODBC Connect Str�s in the Property Sheet?

ODBC;DSN=DMH_Hub;Description=DMH_Hub on
MZPRODEDWADHOC;UID=mzbrosb;DATABASE=DMH_Hub;Truste d_Connection=Yes

ODBC;DSN=DW1;Description=DW1 on MZPRODDW;UID=mzbrosb;Trusted_Connection=Yes

Or better yet, is there a way to specify the connection of the query to
automatically be whatever connection the linked tables are using?
--
Tyro from Missouri

Pass-through queries run on the server, not in Access, therefore unless the
DBMS you're using on that server supports multiple connections, you're out
of luck. Note that you'd have to define the connections on the server, not
in Access.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Tyro" wrote in message
...
When creating a Pass-Through Query, is there a way to create two or more
"ODBC Connect Str"s in the Property Sheet?

ODBC;DSN=DMH_Hub;Description=DMH_Hub on
MZPRODEDWADHOC;UID=mzbrosb;DATABASE=DMH_Hub;Truste d_Connection=Yes

ODBC;DSN=DW1;Description=DW1 on
MZPRODDW;UID=mzbrosb;Trusted_Connection=Yes

Or better yet, is there a way to specify the connection of the query to
automatically be whatever connection the linked tables are using?
--
Tyro from Missouri