ADO vs DAO in Access 2003

[Robert]

In Access 2003 help, is there more VBA examples using ADO
than there is in Access 2002.
I am currently using Access 2002 and DAO examples are
everywhere, however ADO examples are rare!!!

Is this changed in Access 2003.

Anyone!!!

Robert.

 

[Brendan Reynolds \(MVP\)]

Well, if I open the VBA editor in Access 2003 and type 'ADO' in the 'Type a
question for help' box, I get 100 results (I think 100 is the maximum the
task pane will list). They all appear to be relevant, judging by the
titles - obviously I have not looked at them all!

There are many reasons why I prefer DAO rather than ADO when working with an
Access front end and a Jet database, but lack of documentation isn't one of
them. If you can't find what you're looking for in the VBA help, you'll
almost certainly find it either by opening the ADO help file directly
(search for 'ado*.chm') or in the MSDN library ...

http://msdn.microsoft.com/library/default.asp?url=/code/list/dataaccess.asp

While the emphasis there is now on ADO.NET, there's still plenty of ADO
material around under Data Access/Technical Articles and Data
Access/Reference.