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

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?

Douglas J. Steele

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question