ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ODBC Passwords saving in Excel queries (https://www.excelbanter.com/excel-discussion-misc-queries/228054-odbc-passwords-saving-excel-queries.html)

Brian

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?



All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com