Using an Access database on LAN, there is a connection to Mainframe, specifically db2 table(s) using ODBC connection. There will be multiple users accessing the "Access" database. Since the Mainframe resets passwords every 90 days and the password and login ID are hardcoded, is there a way to set-up a parameter so that the UID(user id) and password(pwd) can be used for each user, instead of a "hardcoded" UID and pwd. Below is the code used for the hardcoded sign in to the db2 tables.
ODBC;DSN=DB2P;UID=A123B01;PWD=cool;DBALIAS=DB2P;. Any ideas??