Sql Server 2008: Odbc Connection Problems

I am able to successfully connect from access 2007 into SQL Server 2008 using ODBC; however it prompts me with the password each time. When I try to open the linked table from acce

Solution 1:

When you link tables, there is a option to check that says to remember your password.

So, during the table link process there is a box you need to check to remember your password. You will find that box here:

So, I would try checking the box that says to remember your password when linking a table and see if that helps.