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
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