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?
|