Accept & Use ODBC Login

[wpiet]

How can I have a user enter login username & password to be used for multiple
ODBC connections? I have a workbook with multiple sheets, each with a DB
query. My macro steps thru each sheet, refreshing the data.
For each 'Selection.QueryTable.Refresh,' the user must re-enter id &
password. How can I modify this to have the user enter this info only once &
use it for each subsequent refresh?

 

[Paul]

This can be hard coded into the QueryTable connection string. However
there are security and confidentiality implications.

Paul

 

[Paul]

Sorry I hit the wromg button
For instance a connection string to an Access database, with individual user
and password login, will look like this

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet
OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;

Have a look on these links
http://www.connectionstrings.com/
http://www.sqlstrings.com/
http://www.dofactory.com/Connect/Connect.aspx

Paul

 

[wpiet]

Thanks, Paul. That is very helpful.
Sorry my post is repeated numerous times. Every time I tried to post, I got
an error saying the post was not received, so I'd try again a few hours
later. Now, I see they're all here.