ODBC Links do not save passwords in Windows 7 x64

Had a really interesting one today, setting up an ODBC link into SQL Server 2005 from Access 2007 and no matter what we did the password field would not save the password for our SQL Account.

The customer knew the account worked and the DSN settings on another computer so we were confident it was not those that were at fault.

Well the problem turns out to be Windows 7 x64 and the ODBC applet that is in Administrative Tools.  This is the x64 version and we need the 32bit version for Office to make the link as Office is 32bit.

So we go to this location

c:\windows\sysWow64\odbcad32.exe

If you run this you get the 32bit version of the ODBC applet and its exactly the same, enter your details and hey presto the link works and Access pulls down the data!