Hi,
From my experience Access 2003 is compatible with SQL Server 2005 for projects but you dont get the ability to modify the back end. I have read somewhere a patch is needed for this which Microsoft will not be releasing. I have upgraded to Office 2007 for this reason.
Hope this helps.:)