• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. MAKING THE CHOICE: MDB OR ADP... > USING MICROSOFT DATABASE VERSUS ACCE...

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint