How to pass a password parameter into database sign on box when opening an ODBC table in Access?
Hi All,
I currently have ODBC linked tables in an Access database that are connected to an iSeries. I was informed before that if I click the "Save Password" check box upon selecting the tables that I would not be prompted to enter my password anymore upon initial opening of the table- that has proven to be wrong. If I sign off and sign back on and then open my db up and open a linked table it prompts me for a password and I know I selected that checkbox. Is there anyway that I can establish the connection in Access and force the password to be entered upon the db opening? I want some queries to run when I'm not logged in and the script works; however, it gets hung up because the iSeries login is prompting for a password.
Thanks.
-Anthony
I currently have ODBC linked tables in an Access database that are connected to an iSeries. I was informed before that if I click the "Save Password" check box upon selecting the tables that I would not be prompted to enter my password anymore upon initial opening of the table- that has proven to be wrong. If I sign off and sign back on and then open my db up and open a linked table it prompts me for a password and I know I selected that checkbox. Is there anyway that I can establish the connection in Access and force the password to be entered upon the db opening? I want some queries to run when I'm not logged in and the script works; however, it gets hung up because the iSeries login is prompting for a password.
Thanks.
-Anthony
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You'd be a little better off if you setup a specific account just for this purpose and never change the password.
If the password and/or user does change, then you'll need to drop all the table links and re-create.
Better approach then is to encode the username and password as part of the connect string. Since you have program control over the connect string, you can have a utility update it without deleting all the links.
Of course, the user name and password can then be exposed by someone with a little knowledge.
Jim.
If the password and/or user does change, then you'll need to drop all the table links and re-create.
Better approach then is to encode the username and password as part of the connect string. Since you have program control over the connect string, you can have a utility update it without deleting all the links.
Of course, the user name and password can then be exposed by someone with a little knowledge.
Jim.
ASKER