How to automate the password for a Pass-thru query

I have an Access application that uses DB2 tables via ODBC pass-thru queries. The pass-thru queries have connection strings that are hard-coded with UID and Password. Is there a way to store this info in a table somewhere so each time I have to reset my mainframe password i dont have to go into many many queries and change the password. I would like to change the password in a file stored someplace and have the pass-thru connection string read that value. It would save a lot of aggravation every three months.

Thanks

0 answers