View Full Version : Access to SQL Server 2008


matthewnsarah07
06-24-2008, 07:32 AM
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
06-24-2008, 08:31 AM
Install the 2008 ODBC driver on your client? I imagine that would be on the 2008 disk or on Microsoft's web site.