DAO or ADO

[nicknameoscar]

Several years ago when I started to learn Access I had Access 2000 and couldn't afford anything newer at the time. Thus I purchased (used) books for Access 2000. Many (if not most) of these books seemed to indicate ADO was the way to go (at least that was the way I was understanding them - maybe I was wrong).



On this forum it seems EVERYTHING posted by the experts is DAO (is it even still called DAO?). So, am I to assume that DAO is the preferred technology? I would be interested in hearing comments.

I have to say that starting off knowing nothing whatsoever about Access or VBA I find them extremely interesting and powerful but also frustrating. It seems that for every one thing I learn I realize there are 100 things yet to learn. I guess that is life.

[ajetrumpet]

it's anyone's contention about this whole thing. It doesn't matter. In this day in age when computers are built soley for the purposes of streaming media, data methods really dont matter anymore. Seriously, they don't.

I wrote an article not too long ago this comparison here: http://www.databasedev.co.uk/ado_vs_dao.html

there's probably something to learn from it. If I learned something from writing it, I'm sure anyone can learn something!

[evander]

I use DAO when creating Access DB's that work on their own. I find it much easier than ADO. I used to use ADO when I had to use VB6 for my front-end.