Monte,

It took me several tries to fix this when I switched to Access 2007 but the trick is to check the save password box in the link tables screen. The checkbox is on the right-hand side of the link tables screen that appears at the end of dsn setup routine. You may need to delete your dsn settings and set them up again. After you finish the ODBC setup part of the dsn setup wizard, the sql server login box opens. Put in the correct sql login and password, clock OK. Then the link tables dialog opens and you can check the save password box. Access will give a security warning about not being safe to save passwords but I just ignored their warning.

Access security is getting so strict no one can use it.