ODBC Passwords saving in Excel queries

B

Brian

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?
 

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

Top