ADPs and SQL Server 2005
While I've never been a fan of Access ADPs for various reasons, I know some of you are using them. You might want to stop now, since there's likely to be some issues with them working well with SQL Server 2005. Mary Chipman from MS (responding to queries in the SSXE newsgroup) put it thusly:
However, for new application development, ADPs aren't looking so promising, especially if you are thinking in the Yukon timeframe. A couple of problematical issues are complex data types and CLR assemblies. Tackling these head-on in the ADP UI graphical tools in the next version of Access is a daunting challenge, to say the least.
...and...
FWIW, the Access team has moved away from recommending ADPs as a front-end to SQLS apps over the last year or so, based on several public talks given by team members at industry conferences. If you are contemplating new development with Access as a FE to a SQLS BE, you'll likely be ahead of the game with an efficiently-designed MDB/linked table solution rather than an ADP.