Setting ODBC Connection string of Pass thru query dynamically

J

Jayashree Krishna

Hi,

I have the ODBC Connect str of access 2000 pass thry query ,pointing to
oracle driver.How can I set the ODBC Connection string of Pass thru query
dynamically from the VBA code. I want the string to point to production
environment or development environment based on the choice the user makes.

Any help is greatly appreciated.

Thanks,
Krishna
 
Top