USING MICROSOFT DATABASE VERSUS ACCESS DATABASE PROJECT
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.
Tip
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
