ODBC - Link

[Lobmeister]

I am building an Access data base which needs to link to a few Oracle based tables via ODBC. This works fine except everytime the database is opened and I try to access these tables it asks me for the Userid and password for this connection - is there any way I can automate this process so that on accessing these tables I do not need to pass these values manually ?

 

[THoey]

When you create the link, I believe there is a checkbox for saving the password. Terry M. Hoey

 

[Lobmeister]

Unfortunately I dont have that option - i was wondering if it could be done in vba using connect strings perhaps

 

[borg2002]

This is what I am using. As long as you don't close the connection, you don't have to re-enter your username and password.

strc = "dsn=DSNName;uid=" & Form_frmLogin.txtUserName & ";pwd=" & Form_frmLogin.txtPassword

Hope this helps

Kind regards
Borg