Is ADP Deprecated?

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

http://office.microsoft.com/en-us/access-help/create-an-access-project-HA010341589.aspx

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

verb (used with object)

1.

to bear or hold up (a load, mass, structure, part, etc.); serve as a foundation for.
2.

to sustain or withstand (weight, pressure, strain, etc.) without giving way; serve as a prop for.
3.

to undergo or endure, especially with patience or submission; tolerate.
4.

to sustain (a person, the mind, spirits, courage, etc.) under trial or affliction: They supported him throughout his ordeal.
5.

to maintain (a person, family, establishment, institution, etc.) by supplying with things necessary to existence; provide for: to support a family.