DAO to ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: DAO to ADO

  1. #1
    CodePuppy Guest

    DAO to ADO


    Debbie,
    I was at VBits New York last year and really enjoyed your one day workshop
    on OOP in VB. I got a lot out of that and went on to another presentation
    by you as well. I also make an effort to read your columns in VBPJ -- of
    course, I'm a couple months behind
    But I have a few questions for you:
    (1) I have a VB application written using DAO. I want to port this
    to ADO for multiple reasons, but I dread the port due to having to change
    all the data bound visual controls to the ADO equivalent --> DBGrid to DataGrid,
    DBCombo to DataCombo, etc. Is there any way to make this easier?
    (2) I'm looking for a flexible report-writing tool for VB 6.0. I'd
    like it to run (at least) as an ActiveX out of process server and give me
    output as either HTML or RTF. Emailing and HTTP Posting of reports would
    be cool too. Do you know of a good third party package that will do all
    or most of this?
    (3) Lastly, I've noticed that even using the Jet 4.0 library in VB5 or
    VB6 does not allow the DAO Data Control to access a converted (to Access
    2000) database. Do you know of a work around for this? I have an app where
    all the users have moved to Access 2000 and we can not get a VB DAO applications
    to work with Access 2000 due to this limitation. This is the same app that
    we want to convert to ADO, so we don't want to change all the DataControls
    now just to buy a few more months before we can begin the conversion.
    Thanks for your help and I'm looking forward to seeing you again in
    the not too distant future at another VB event.
    CodePuppy

    Share on Google+

  2. #2
    Deborah Kurata Guest

    Re: DAO to ADO

    Hi -

    Thanks for the kind words about my workshop.

    With regard to your questions:
    1) I don't know of an easier way to do this.
    2) We use Crystal. I don't know whether there is something better out there.
    3) Someone asked this earlier in this newsgroup and were provided with an
    answer. You may want to look back at the prior messages.

    Good luck!
    Deborah

    CodePuppy wrote in message <38ff36ca$1@news.devx.com>...
    >
    >Debbie,
    > I was at VBits New York last year and really enjoyed your one day

    workshop
    >on OOP in VB. I got a lot out of that and went on to another presentation
    >by you as well. I also make an effort to read your columns in VBPJ -- of
    >course, I'm a couple months behind
    > But I have a few questions for you:
    > (1) I have a VB application written using DAO. I want to port this
    >to ADO for multiple reasons, but I dread the port due to having to change
    >all the data bound visual controls to the ADO equivalent --> DBGrid to

    DataGrid,
    >DBCombo to DataCombo, etc. Is there any way to make this easier?
    > (2) I'm looking for a flexible report-writing tool for VB 6.0. I'd
    >like it to run (at least) as an ActiveX out of process server and give me
    >output as either HTML or RTF. Emailing and HTTP Posting of reports would
    >be cool too. Do you know of a good third party package that will do all
    >or most of this?
    > (3) Lastly, I've noticed that even using the Jet 4.0 library in VB5 or
    >VB6 does not allow the DAO Data Control to access a converted (to Access
    >2000) database. Do you know of a work around for this? I have an app

    where
    >all the users have moved to Access 2000 and we can not get a VB DAO

    applications
    >to work with Access 2000 due to this limitation. This is the same app that
    >we want to convert to ADO, so we don't want to change all the DataControls
    >now just to buy a few more months before we can begin the conversion.
    > Thanks for your help and I'm looking forward to seeing you again in
    >the not too distant future at another VB event.
    > CodePuppy
    >



    Share on Google+

  3. #3
    Phil Weber Guest

    Re: DAO to ADO

    > I have a VB application written using DAO. I want
    > to port this to ADO for multiple reasons...


    Puppy: You might read the following article and see if it helps:

    Migrating from DAO to ADO
    ( http://msdn.microsoft.com/library/ps...k/migr4yun.htm )

    > I'm looking for a flexible report-writing tool for VB6


    Check out ActiveReports from Data Dynamics
    ( http://www.datadynamics.com/products...ts/arinfo.html ).

    > I've noticed that even using the Jet 4.0 library in VB5
    > or VB6 does not allow the DAO Data Control to access
    > a converted (to Access 2000) database. Do you know
    > of a work around for this?


    See the following article in the Microsoft Knowledge Base:

    PRB: Getting Unrecognized Database Format Error Message
    When Upgrading to Access 2000
    ( http://support.microsoft.com/support.../q238/4/01.asp )

    ---
    Phil Weber


    Share on Google+

Similar Threads

  1. ADO vs. DAO with MS Access database
    By Yiwen Chung in forum VB Classic
    Replies: 2
    Last Post: 02-21-2001, 02:29 PM
  2. ADO or DAO?
    By Geoff Engelstein in forum VB Classic
    Replies: 5
    Last Post: 11-16-2000, 11:54 AM
  3. ADO or DAO?
    By Jeff Hetzler in forum VB Classic
    Replies: 3
    Last Post: 10-24-2000, 01:34 AM
  4. ADO Syntax, from DAO to ADO, from Access to SQL
    By T. Bradley Dean in forum VB Classic
    Replies: 2
    Last Post: 09-13-2000, 09:47 PM
  5. ADO Filter compared to DAO
    By Chris Savage in forum VB Classic
    Replies: 0
    Last Post: 08-30-2000, 09:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center