http://www.access-programmers.co.uk/forums/showthread.php?t=182076

Welcome to the world of Access clients that use SQL Server back-ends.

While I did not transfer my Access 2003 (run time) application from Oracle to SQL.

I did recentlly update it from SQL 2005 to SQL 2008

This is one of a few posts.

The ODBC did require some tweaks since there is a client update from 2005 to 2008 SQL.

Also, during my conversion, it appeard (but I can't prove it) that MS pushed out a change that added some compatibility.

Bottom line - most ODBC solutions for Access are on the site above.

This, however is the best site for SQL Server.