Accept & Use ODBC Login

W

wpiet

In a workbook with multiple sheets, each with an associated DB query, how can
I have a user enter ODBC login username & password just once, then use these
to automate each subsequent login as the macro loops thru the sheets,
refreshing data in each.
 

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 & Use ODBC Login 3
Input ID & password once for multiple ODBC logins 0
Accept username & password once; Use for multiple ODBC logins 0
Login User Form 1
Suppressing ODBC Login Prompt 2
If ODBC DSN connection fails 6
ODBC Microsoft Access Login Failed 2
Macro to run external application and login into it. 1

Top