Results 1 to 4 of 4

Thread: DAO And ADO

  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    DAO And ADO

    I keep seeing references to DAO and ADO in these posts including instructions for "conversion" (or something similar). Can someone please explain what these terms mean and why/where one has to define them? I am currently using Access 97 on a Windows 98 SR2 machine.

  2. #2
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAO And ADO

    Hey Chuck,
    To the best of my knowledge ADO and DAO appear to be an evolving system of object libraries.
    Apparently, [DAO (stands for Data Access Objects)??] and is found (used) on Access 97 and prior versions
    where[ ADO stands for( Active-X data objects)???] and it is employed in Access 2k and up .

    I imagine that ADO is much more powerful and inclusive in that you can integrate all or most objects from the MS library of apps, because they are created using Visual Basic (The official language of MS). DAO being an earlier library was probably the stepping stone or prototype of ADO development.

    As a fellow Access 97 user, the only thing I would caution you about is grabbing code from this site where the developers are working in Office2k. You'll have to change the reference to included MS DAO 3.51 object library to accomodate some of this code. One of the experts can set you up on this.
    I could be off a bit...but HTH anyways.
    <font color=blue>......and now the clarification.</font color=blue>
    <img src=/S/warts.gif border=0 alt=warts width=59 height=24>
    I LOVE these smilies!!!!

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAO And ADO

    Thanks a bunch -- at least I now have some idea as to what it's all about.

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

    Re: DAO And ADO

    Actually, MS is moving toward ADO as the object model of choice because it offers tremendous flexibility in working with all kinds of data sources and isn't limited to Jet databases. My understanding is that DAO is largely DOA! That is, it will remain there for backward compatibility, but it is no longer evolving with new versions of Office. DAO is highly Jet-specific, so it doesn't do well with things like ASCII text files or email messages or HTML or XML, and Office is moving in the direction of "universal" data access.

    Both models are still needed in Office 2000, because there are some things you simply *cannot* do with ADO, at least not yet. I'm not sure whether XP still relies as much on DAO because I haven't upgraded yet.
    Charlotte

Posting Permissions

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