Unanswered: Access/SQLExpress can't find server error
Hi. I'm trying to use Access07 with service pack 1 (project) as the front end to SQL Server Express 08 back end and get a "could not find SQL Server specified" error message. Note that the server is on my local PC, the same PC where Access07 is on. I have successfully created a database and migrated some data from an Access 2000 file format into SQL Express 08 using MS SQL Server Management Studio. I open SQL Management Studio and I see the server name (computername\SQLEXPRESS) and the database. Then, while keeping SQL Server Management Studio running or not (tried both), I go into Access (project) and try to connect to the data using Windows authentication, I get the "could not find DQL Server" error. I would really appreciate some ideas of what the problem could be?