Input ID & password once for multiple ODBC logins

W

wpiet

In a 2003 workbook, I loop thru multiple sheets, each with a DB query, &
refresh the data. How can I, just once, accept the username & password & use
these for the ODBC login for each subsequent query?
 

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

Accept username & password once; Use for multiple ODBC logins 0
Accept & Use ODBC Login 3
Accept & Use ODBC Login 0
If ODBC DSN connection fails 6
ODBC Password 0
ODBC QueryTable Location (Cell address) 2
Can I pass the logon credentials in a macro to a ODBC query 1
Suppressing ODBC Login Prompt 2

Top