DAO / ADO

[Emergency Power]

I have developed an application in Acces using DAO. I want to be with the
times and convert to ADO. Is There a program to change all my code to ADO ?
And what are the major advantages of ADO ?
Tahnk you for advise,

 

[Tom van Stiphout]

On Sun, 22 Feb 2009 10:39:01 -0800, Emergency Power

Leave it the way it is, and focus on more important issues. ADO is not
better than DAO in a pure Access (FE + BE) environment.

Also curious that you were considering changing BEFORE you knew the
major advantages.

-Tom.
Microsoft Access MVP

 

[Emergency Power]

Thank you for your response. I did ask what the major advantages were so
that I could determine if I would change. I read a few books that said if
you were to make a program it was best to use ADO because DAO is likely going
to be phased out. " The newer ADO is currently favored be Microsoft, meaning
that ADO will continue to grow and Get better while DAO remains in
Maintenance mode, which generally spells doom for the technology. If a
technology is in maintenance mode today, that pretty much guarantees that it
won't exist at all in the not-to-distant future."
Your reply is appreciated.

 

[Rod Plastow]

I suggest you look at the publication date of those books. That advice had
me converting from DAO to ADO about six years ago. Now I've had to reconvert.

 

[Fred]

I'm in the dummy section on this topic but that might make my summary useful.

I think that they started going to ADO in 2002 and then reversed themselves
and went back to DAO. The developers book that everybody considers to be
the best came out in 2002 and so is "backwards" on this topic.

 

[David W. Fenton]

I want to be with the
times and convert to ADO.

If by "with the times" you mean the year 2000, then go for it.

If you mean the present day, then don't.

 

[David W. Fenton]

I suggest you look at the publication date of those books. That
advice had me converting from DAO to ADO about six years ago. Now
I've had to reconvert.

Many of us saw the folly in using ADO for Jet databases at the time
MS was recommending and didn't convert. I'm not sure why anyone
thought it was a good idea in that environment.

 

[David W. Fenton]

I think that they started going to ADO in 2002 and then reversed
themselves and went back to DAO.

MS started pushing ADO in Access with the release of Access 2000,
which was in June 1999. By the release of Access 2002, they'd
started backtracking, and by Access 2003, had completely reversed
course. Access 2007 represents a complete return to the supremacy of
DAO over ADO.

 

[Rod Plastow]

Aye, but it was the threat of withdrawn support that motivated me. Was it
more than 6 years ago?

BTW I've just converted an ADO application to DAO (local Jet DB only) and my
gut feel (no precision here) is that DAO runs 25% faster than ADO in this
situation.

Rod

 

[John W. Vinson]

BTW I've just converted an ADO application to DAO (local Jet DB only) and my
gut feel (no precision here) is that DAO runs 25% faster than ADO in this
situation.

Doesn't surprise me a bit.

ADO is still useful in an environment with heterogenous data stores in the
backend. In a pure JET (ACE) database, it has no benefits that I've seen.

 

[David W. Fenton]

Aye, but it was the threat of withdrawn support that motivated me.

I don't recally any such threat. There were, of course, all those
comments by non-MS employees about Jet being obsolete and deprecated
and all that, but I never believed any of it, as I couldn't see what
could possibly replace Jet (and based on Access 2007 and the ACE, MS
seems to agree with me on that).

Was it
more than 6 years ago?

Absolutely. And it's been a very long time now since MS changed
their tune and started making sense again.

 

[Tony Toews [MVP]]

Many of us saw the folly in using ADO for Jet databases at the time
MS was recommending and didn't convert.

Many of us, ok me, were too lazy to be bothered to convert from DAO to
ADO. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/