ODBC with SQL-Server does not store password in DSN

[JohanM]

I use a attachted SQL-Server table in MS-Access. In the ODBC-DSN configuration I have typed username and password.
When I try to open de SQL-tabel in MS-Access, ODBC asks me for the password because the passwordfield in the DSN is empty. Why does ODBC not store the password?

If somebody knows the answer it would be great.

 

[tlbroadbent]

You may be encountering a known bug. Check the following article.

FIX: SQL Server ODBC Driver Ignores Authentication Setting

http://support.microsoft.com/support/kb/articles/Q279/5/26.ASP

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.