Accept username & password once; Use for multiple ODBC logins

W

wpiet

In a 2003 workbook with multiple sheets, each with a DB query, how can I have
a user enter username & password one time, then use these for each subsequent
ODBC login (to the same server) as I loop thru the sheets?
Now, each time the program hits 'Selection.QueryTable.Refresh,' the user has
to login again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input ID & password once for multiple ODBC logins 0
Accept & Use ODBC Login 3
Accept & Use ODBC Login 0
Code Problem 1
If ODBC DSN connection fails 6
Refresh Queries in All Worksheet 2
Username and password login. 10
username and password when login 1

Top