<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