| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accept username & password once; Use for multiple ODBC logins
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. -- Will |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accept & Use ODBC Login | Excel Programming | |||
| Input ID & password once for multiple ODBC logins | Excel Programming | |||
| Accept & Use ODBC Login | Excel Programming | |||
| Excel 2000 required multiple user name and password logins | Excel Programming | |||
| Required multiple user name and password logins for database query | Excel Discussion (Misc queries) | |||
Linear Mode
