View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default ODBC Passwords saving in Excel queries

I connect to data on my iSeries thru a Client Access ODBC driver. Sometimes
the spreadsheet will capture the my signon and when another user tries to
open/refresh the data it prompts them with my userID. I am unsure how this
is being done because it only happens to spreadsheets where I tried to use
the excel protection feature so the user couldn't change the text on the main
tab. Does anyone know how to prevent excel from capturing my login info?