Results 1 to 8 of 8

Thread: DAO versus ADO

  1. #1
    DaveShmave
    Guest

    DAO versus ADO

    I just have a general question as to why Microsoft decided to make the move to ADO in Access 2000 rather than stay with DAO like in Access 97?

    I'm really curious about this. Do any of you have any information you can share? Or perhaps articles you can refer me to?

    TIA

    Dave

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAO versus ADO

    According to Access 2000 Developer's Handbook (page 220), the ADO object model is part of a wider Microsoft initiative, known as Universal Data Access (UDA). Apparently, the older data access libraries such as DAO and RDO are not up to the task of being able to retrieve data from any data source (not just records in tables), as envisioned by MS engineers.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAO versus ADO

    DAO still works in Acess 2000 once you set the library reference, and it's actually faster for some things. However, DAO is pretty Jet-specific. There isn't a lot of support for UI objects the way there is in DAO, so it's more work to do some tasks.

    The learning curve is fairly steep with ADO because there are so many ways you could do something, and not all of the are the right way or the best way. But after quite a few false starts and a lot of cussing [img]/w3timages/icons/aflame.gif[/img], you get the hang of it and it starts to feel natural. If you want to exchange data through XML, or work with recordsets that have been "persisted" to a special kind of file that makes them portable between machines and applications, or really use the power of the new ADPs, you're going to need to learn ADO.
    Charlotte

  4. #4
    DaveShmave
    Guest

    Re: DAO versus ADO

    Thank you Ken and Charlotte, that gives me a better understanding.

    It sounds like the change was made so Access would be more web friendly (...exchange data through XML,... ...use the power of the new ADPs,...)? Is that a correct interpretation?

    Thanks again for your replies.

    Dave

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAO versus ADO

    Not exactly. It's more of a recognition that data doesn't necessarily live in databases and that there's a need to work with a much wider variety of possible data sources. ADO is flexible enough to handle things besides ODBC-compliant database files, spreadsheets, and text files. And it gives you ways to connect to those data sources besides the traditional links. It also allows you to handle them in different ways.
    Charlotte

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: DAO versus ADO

    so it's not a case of much ADO about nothing?[img]/w3timages/icons/grin.gif[/img]
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAO versus ADO

    Aaaaaarrghh![img]/w3timages/icons/scream.gif[/img][img]/w3timages/icons/scream.gif[/img][img]/w3timages/icons/scream.gif[/img] Rory, I'll get even with you for that one!
    Charlotte

  8. #8
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: DAO versus ADO

    sorry - been reading too many of Geoff's posts...
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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