"Sasha" wrote
Can anyone recommend a good book or website for
information on using ADO?
The successor to "Classic ADO" as used in Access is "ADO.NET" which is used
in Microsoft Visual Studio.NET. Thus, "classic ADO" is a dead-end product
and there is little to recommend it unless you have specific needs in
dealing with Access clients to Microsoft SQL Server, or you are using
classic ASP web pages, or VB v6.0.
It is not, repeat NOT, better than DAO for use in Access with the default
Jet database engine, because DAO is the native language of Jet. And some
knowledgeable Microsoft insiders now state that, in many cases, using Access
MDB, Jet, and ODBC to access server databases is preferrable to using Access
ADP, ADO, and the server's ADO data provider.
That said, the best book I know for learning ADO is the Microsoft Press Book
by Dr. Rick Dobson, "Programming Microsoft Access <Access versionnumber>". I
have the Access 2000 and 2002 editions and both have excellent coverage in
this area. I think there is also an Access 2003 version, but I don't have a
copy of that one.
Larry Linson
Microsoft Access MVP
