ODBC and password

[SHIPP]

I am working in Access 2003. I simply want to issue a command with the ODBC
connection information that includes the password so that the user does not
have to enter it. The following represents the string I want to send.

ODBC;DSN=adage_bck;DB=adage_p;HOST=adage_bck;SERV=aifx20;SRVR=aifx20;PRO=onsoctcp;UID=mship00;PWD=mship00

Any help would be appreciated.

 

[pietlinden]

I am working in Access 2003. I simply want to issue a command with the ODBC
connection information that includes the password so that the user does not
have to enter it. The following represents the string I want to send.

ODBC;DSN=adage_bck;DB=adage_p;HOST=adage_bck;SERV=aifx20;SRVR=aifx20;PRO=onsoctcp;UID=mship00;PWD=mship00

Any help would be appreciated.

Should be here somewhere... what database are you connecting to?
http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForODBCDatabases