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

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

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

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