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?
--
Will

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

Paul


"wpiet" wrote in message
...
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?
--
Will

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

"Paul" wrote in message
...
This can be hard coded into the QueryTable connection string.
However there are security and confidentiality implications.

Paul


"wpiet" wrote in message
...
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?
--
Will

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.
--
Will


"Paul" wrote:

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

"Paul" wrote in message
...
This can be hard coded into the QueryTable connection string.
However there are security and confidentiality implications.

Paul


"wpiet" wrote in message
...
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?
--
Will