DAO vs ADO

[ions]

I would like to know how many people use DAO vs ADO.
I only know DAO but am considering learning ADO. Just wanted to know if it's
worth it.

 

[boblarson]

I haven't used DAO that much, as ADO became the default in A2K and A2K2, but since DAO is now the default for A2K3, I am probably going to start using it more. Pat Hartman has posted that DAO is actually much more robust when using the Jet Engine than with ADO and DAO can do more than ADO when used with Jet.

I liked ADO myself due to the fact that the syntax seemed easier to me than DAO.

 

[Steve R.]

This is a question that I have been wondering about. I hope that their will be many comments.

 

[ions]

DAO is the standard for 2k3? Wow I didn't know that. How about for 2k7? I thought MS wanted us to switch to ADO. Surprised to hear that it was made the defautl in 2k3.

 

[ChrisO]

Here is a well-written dialog on the subject that also covers A2007.

Regards,
Chris.

 

[ions]

That was a good article. Thanks Chris0.

 

[Ron_dK]

SJ McAbney has posted a lot on DAO/ADO.

Here's one post :
http://www.access-programmers.co.uk/forums/showthread.php?t=98092

Do a search on DAO and SJ and you'll find lot's of hits.


Hth

 

[gemma-the-husky]

I started with DAO in Access 97, and didn't see the ponit in learning ADO, especially as it didn't do everything! DAO did everything I needed it to anyway.