The choice of whether to use MDB versus ADP actually follows the Jet versus client/server choice pretty closely. ADP, used as a front end for SQL Server, contains tools for editing not only Access objects such as forms and Data Access Pages, but also views and stored procedures.

Microsoft has also come up with a desktop solution to use with the ADP, known as the Microsoft Data Engine (MSDE). This is generally aimed at small workgroup applications. Generally, you want to use an ADP with MSDE when you think you will be moving your application to the full functionality of SQL Server 7.


You can also use the MSDE to test your ADP and then easily modify the connection string to hook you up ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.