I am linking an Access database to SQL Server 2008 using ODBC. I use the 2008 drivers and I can set up the link and it tests fine. In the database I can open the tables and edit/view the table's data. When I open a form I get an error: Connection failed: SQL State: '08001' SQL Server Error: 10061 [Microsoft][SQL Server Native Client 10.0]TCP Provider: No connection could be made because the target machine actively refused it. If I click ok and then ok on the next SQL Server Login popup (Using trusted connection) it will display the form and the data. Any ideas? I have made sure the allow remote connections was enabled and also tried different protocols.