ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Security when using external data (https://www.excelbanter.com/excel-discussion-misc-queries/54137-excel-security-when-using-external-data.html)

MarkInSalemOR

Excel Security when using external data
 
I would think the answer is here somewhere but I'm not finding it, so here
goes.

In Access when a table is linked in and the password is saved it's fairly
easy to read the password by opening the MsysObjects table. Does Excel have a
similar vulnerability when an external data source is setup? We use a
universal login and password and then use another application to prevent
people from opening things they shouldn't.

If Excel has a similar vulnerability, is there a work-around?

So far in my exploring settings, opening the xls file in Notepad, etc I'm
not finding the DSN or the login and password. So I'm thinking this is not an
issue.

Thanks
Mark


All times are GMT +1. The time now is 06:13 AM.

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