Thread: Accept username & password once; Use for multiple ODBC logins
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wpiet wpiet is offline
external usenet poster
  
Posts: 23
Default 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 With QuoteReply With Quote