Changing the connection of a pass thru query

Topic

New Reply

I need to change the ODBC Connection String of all of the pass through queries in a database.

Pass Throught queries do not seem to be a part of the querydefs collection.

How do I address pass through queries in code so that I can modify the connection string?

Version Access 97, yep 97!

Reply | Quote

Replies

Don’t know how I missed it the first time but they are in the querydefs collection and the connect property can be modified.

Reply | Quote