More on Access ADPs and SQL Server 2005
Mary Chipman from Microsoft gave one the most complete yet compact answers on this topic yet.
...There are no plans for supporting designing SQL Server objects using Access ADPs either now or in the future. You can use Access to connect to a SQL Server 2005 database in 2000 compatibility mode, but there is no support for new 2005 functionality being planned. It is recommended that you use the client tools in SQL Server for creating new SQL Server objects. There is also support in Whidbey for creating SQL Server objects.
'nuff said!