Access Data Projects provided a lightweight front end to Microsoft SQL Server with Access versions from 2000 to 2010. Note ADP was deprecated in Access 2010 and is unsupported as of Access 2013.
Access Data Projects (introduced with Microsoft Access 2000) provide a lightweight front end to to Microsoft SQL Server.
An ADP can only connect with one database on one server, but the full range of SQL queries is made available by the ADP's ability to create views and stored procedures that are stored on the server.
Bugs can occur when connecting with schemas other than dbo, such as support for extended properties (where the ADP stores settings such as combo box data source and column widths).
ADP was deprecated in Access 2010 and is no longer supported as of MS Access 2013. Because of this, some functionality is lost when connecting to SQL Server 2012 and later, as the ADP no longer supports altering the date/views/stored procedures.
