I hear a lot of MVPs claim that ADP is deprecated.. It’s silly that there’s a religous war between SQL Server architects and developers who continue to be strangled by Jet.
So I thought that it was time to explain… Straight from the horses mouth
Recommendations for Access projects in Access 2010
We continue to support creating and working with .adp files in Access 2010. However, we recommend that developers use the SQL Server design tools provided in SQL Server Management Studio to design database objects such as tables, views and stored procedures, and then use the Access interface to design the forms, reports, macros and modules that connect to those objects. The tools provided by SQL Server provide the most powerful interface for creating SQL Server objects.
PLEASE NOTE THE WORD SUPPORT
http://sp.dictionary.com/dictstatic/d/g/speaker.swf [suh-pawrt, -pohrt] Show IPA