Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    ADP vs MDB (Access 2003 SP3)

    A few questions.
    I notice there are a few companies using ADP these days, where is the trend going?

    Is ADP slowly dying?

    Is ADO the way to drive ADP databases?

    Is ADO faster that ODBC?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ADP vs MDB (Access 2003 SP3)

    Let's look at terminology first.

    ADO, like DAO, is a data object model - a programming interface that lets you manipulate (data in) a database in code. ADO is more general and more flexible, but DAO is more tightly integrated with Access, so often easier to program, and (for Access) faster.

    ODBC, like OLE DB, is a way to connect to external data sources such as a SQL Server database.

    So ADO vs ODBC is not a valid comparison - they have different purposes.

    For a while, Microsoft pushed ADPs as a way to provide a frontend to SQL Server databases, connecting through OLE DB, and ADO was the preferred object model.

    During the last few years however, they have moved away from that again, and now they recommend using an MDB database with linked tables, connecting through ODBC, and with DAO as the object model of choice.

    ADPs will still be supported (they are in Access 2007), but there will probably be no new features, and they might be dropped in a future version.

    You can download a long Word document that describes Microsoft's current ideas about Access: Microsoft Office Access vision white paper.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: ADP vs MDB (Access 2003 SP3)

    Thanks for the correction in terms.

    I will check out those references.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •