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.