Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DAO 3.5 Library (VB6)

    I notice DAO 3.5 Object Library can be selected from references.

    Does this mean the same code and syntax can be used within Visual Basic ?

    How and Would this need referencing to use it ?

    I have a small database I wish to convert to a VB Executable !

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: DAO 3.5 Library (VB6)

    You're migrating code from Access to VB? Maybe DAO would be a good choice. Otherwise, using the ADO object model probably is a better choice, as it is Microsoft's more "modern" database API.

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

    Re: DAO 3.5 Library (VB6)

    DAO 3.5 is for the Jet 3 engine, corresponding to Access 97. You should use a reference to the Microsoft DAO 3.6 Object Library. This is for the Jet 4 engine, corresponding to Access 2000 and higher.

    You can use it the same way you use DAO code in Access, i.e. open recordsets, add records, edit records, etc.

  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 3.5 Library (VB6)

    Only the DAO code, not any general Access-specific code.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAO 3.5 Library (VB6)

    Yes, I meant DAO 3.6, sorry typo error !.

    What I really meant was the syntax I've always been used to with Access.


    DoCmd this and DoCmd that, instead of just working at record movement level, i.e RST this and RST that.

    Does this make sense ?

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

    Re: DAO 3.5 Library (VB6)

    DoCmd, RunCommand etc. are objects in the Access object library, not in the DAO (or ADO) object library. These objects are used to perform actions that are the equivalent of the things you can do in the Access interface interactively. The user would need to have Access installed on his or her PC for a VB6 application to be able to use DoCmd, RunCommand etc., but I suppose the reason you want to convert your Access app to a VB6 app is to avoid that requirement.
    DAO or ADO give you a way to work with the data in an Access database without having Access itself. You manipulate the data through recordsets etc.

Posting Permissions

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