ADP or MBE

[CB]

What is the current concensus Access Project to SQL (ADP) or MBE Linked
Tables to SQL?

We are starting a new project and choosing. Which will be more supported?

Thanks,

vex

 

[Douglas J. Steele]

Microsoft is deprecating ADPs, so you may be best sticking with MDBs (or
MDEs)

 

[Brendan Reynolds]

<quote>
The preferred way to connect to SQL Server is MDB file format or ACCDB file
format. This enables you to use the full flexibility of local tables and
local queries, while leveraging the full power of SQL Server. In addition,
MDB and ACCDB files link to multiple SQL Servers and a wide variety of other
data sources. Office Access 2007 contains many new features available in
both MDB and ACCDB file formats, but only a subset of those features are
available in ADPs.
</quote>

http://technet2.microsoft.com/Offic...ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true