dao vs. ado

  • Thread starter Thread starter Kan D.
  • Start date Start date
Douglas said:
You might be interested in seeing what MichKa has to say at
http://www.trigeminal.com/usenet/usenet025.asp and
Click to expand...

There are some things on the list that are 'grey areas', IMO. One of
the points seems to be a fallacy: one *can* use ADO to create user and
groups and specify the PIDs (as detailed in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acadvsql.asp)
e.g.

CurrentProject.Connection.Execute "CREATE GROUP Billing Gu294JxP1m"
http://www.trigeminal.com/usenet/usenet017.asp
Click to expand...

I think the second article is now out of date e.g. considering the
Access 2007 release.

Jamie.

--
 
Kan said:
somebody tell me the adv/dis-adv to using ado vs. dao
Click to expand...

My summary would be, there are some things that DAO can do that ADO
can't (see the list Doug linked to) and vice versa (notably, ADO can
use the Jet 4.0 functionality and DAO generally cannot).

I think the ADO model is nicer to work with e.g. unlike DAO you don't
have to explicitly create and destroy objects and in a certain correct
order. ADO objects are more feature rich e.g. recordsets can be
disconnected and/or fabricated and/or hierarchical and support
more/improved properties and methods plus, because the can be used
asynchronously, they have events. But then anyone *would* expect ADO to
have improvements, having being built on the success of DAO and learnt
from its failures. I choose ADO because code maintenance

On the other hand, I understand DAO like-for-like offers better
performance. Also, there is a greater body of work in DAO for
Access/Jet e.g. on google you are more likely to find a DAO code
example than an ADO one.

Is anyone forcing you to make a choice, one way or the other? I get the
impression most of the Access MVPs use both ADO and DAO; I think anyone
would be best advised to do the same to be able to enjoy the best of
both worlds.

Jamie.

--
 
Jamie Collins said:
I think the second article is now out of date
e.g. considering the Access 2007 release.
Click to expand...

Access 2007 is only in beta; it has not been released. Until it is actually
released, you can't count on any particular content being included or
excluded -- that's the way release cycles work.

Larry Linson
Microsoft Access MVP
 
LIAR!

if you're using _ANY_ database use ADO so that it's easy to migrate
databases


-Aaron
 
Back
Top