Ms Access And Sql Server 2005

jaydwest

JayW
Local time
Today, 07:15
Joined
Apr 22, 2003
Messages
340
I have just downloaded SQL Server 2005 and created a database using the Management Studio Express.

I wanted to link an MS Access 2000 front end with my SQL Server Database. I tried creating an ODBC connection to the database using the ODBC Data Source Administrator. However, It doesn't seem to recognize the SQL Server 20005 Server I created. How can I link my MS Access Database with the SQL Server Database?

I also have SQL Server 2000 running on my system, and it recognizes it.

Thanks for your help
 
When you say recognize, do you mean that you are clicking on the dropdown and it isn't there, or you have typed in the name of the server and it says it doesn't exist?

You may/will have to type it in the first time ...
 
THe Former
 

Users who are viewing this thread

Back
Top Bottom