DAO to ADO

[CodePuppy]

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

[Deborah Kurata]

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
>

[Phil Weber]

> 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