i have set up SQL Server Express 2005 as a backend and MS Access 2007 as a front end. The operating system on both machines is Windows 7. I have set the login and user name on the SQL Server. I am trying to establish an ODBC connection between the Access 2007 to the SQL server and I keep getting an error message:
SQL State 01000
SQL Server Error 1385
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
SQL State 08001
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist of access denied
I have this same system set up on XP boxes and no problems connecting using SQL server driver.
Please help. Thanks.