Access to SQL Server 2008

[matthewnsarah07]

I am moving my first database over from Access to SQL Server 2008.

I exported all my existing Access data using the supplied utility to the server so the backend is now Leave.mdf

My question is how do I link up Access as the front end as when I go to link data it doesn't recognise the .mdf file, i've tried upsizing and cannot get it to find an OBDC data source.

I am using Access 2000 - is there any quick fixes for this problem

Help!!

 

[georgedwilkinson]

Install the 2008 ODBC driver on your client? I imagine that would be on the 2008 disk or on Microsoft's web site.