It depends what kind of database you are using also.
I *believe* it is the case that DAO is STILL faster in accessing a Jet
database (at least I'm sure
that's what the guy said at the Mastering VB5 course I took this summer),
the sake of software perpetuation, if you can take the small difference ADO
would be much
nicer to develop with. DAO tends to be slower in accessing remote data,
something to do with
it having to call the RDO layer for those calls. DAO is like a wrapper for
access to Jet database
functionality and RDO functionality. So there's a bit of a performance hit
for remote data. ( At
least this is how it was explained to me at this course. )
And I don't believe (correct me somebody if I'm wrong) that ADO does NOT
calls such as the CompactDatabase method for compacting a Jet database
(which DAO does).
So I believe that you need to use DAO for that. And if you're developing
anything that uses a Jet database....you're
probably going to want to get at the CompactDatabase and if one exists the
methods....cuz we all know how reliable Access is once you start fillin' it
up and dumping it out. :-))
By the way.... you can write in RDO in Visual Basic 5.0. It is VERY
similar to ADO by the looks of it, but I'm sure
ADO must have some kind of perk over using RDO. I have used RDO
extensively and have found that it works
great for making remote data calls such as stored procs, etc.
>I am going to build a data base application in visual basic. At the
>moment we have VB5. But I've heard that this summer a new version (6) of
>VB was released, including changes in the database engine. Now , I need
>- are ADO and DAO compatible?
>- do I have to rewrite code when passing from DAO(vb5) to ADO(vb6)?
>- is there a wizard for upgrading from DAO to ADO
>- whether I should buy VB6 and start immediately with ADO; is it worth
>buying a new version of vb5?
>Thanks in advance,