Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Password in DSN File
Hi,
I've recently upgraded from Excel 97 to Excel 2003 and am now having a few teething problems with my old DSN files. It seems that Excel 2003 no longer recognises the passwords held in the DSN file and prompts me for the password everytime I re-open the workbook. I've tried creating a new DSN from 2003, but this too suffers from the same problem. Any ideas? <M |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Password in DSN File
<M
Don't know if this will help but try this KB article. http://support.microsoft.com/kb/213772/#top Gord Dibben MS Excel MVP On 2 Jan 2007 02:47:24 -0800, "<M" wrote: Hi, I've recently upgraded from Excel 97 to Excel 2003 and am now having a few teething problems with my old DSN files. It seems that Excel 2003 no longer recognises the passwords held in the DSN file and prompts me for the password everytime I re-open the workbook. I've tried creating a new DSN from 2003, but this too suffers from the same problem. Any ideas? <M |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Password in DSN File
Gord Dibben wrote: <M Don't know if this will help but try this KB article. http://support.microsoft.com/kb/213772/#top Gord Dibben MS Excel MVP Thanks for the input, but unfortunately neither that article nor any linked articles seem to indicate a resolution to my problem. :-( Any other ideas? <M |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Password in DSN File
Ok,
My misunderstanding. It seems that in 2000 MS became aware of a loophole in the security for documents containing data acquired through a DSN as the document was saving the connection details (including password) in the file in plain text. When the SR-1/SR-1a was released they disabled this feature. To their credit they did allow the user to manually override this new setting and continue to save the un-encrypted connection details with the file, but then why would you want to? It was this fix that was causing me problems as I wasn't expecting it. Now that I know what's going on I can find a new way to share my data. If you are reading this and want to override the fix then simply right click your data in the document and select properties. I think the second option is to save password in file which when checked will do just that. There is also a registry key that will set this flag by default if you realy need to. <M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have fogotton my password for an excel file. please help | Excel Discussion (Misc queries) | |||
Remove or change password protected excel file | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Enter CORRECT password, file doesn't come up? Help | Excel Worksheet Functions | |||
Password error after file opens | Excel Worksheet Functions |