ADO Recordset Literature

[jgelpi16]

Can anyone provide a link or two to some good ADO Recordset information? I have a feeling I am going to be using them more and I am an amateur at best! Thanks!

[ajetrumpet]

what info? the props and methods? You can see them in VBA with intellisense once the SET statement is issued anyway. wouldn't that be the best learning method?

[jgelpi16]

Yea, I just am looking for a general explanation of the capabilities. I know you use them to "connect" to an Excel spreadsheet, or even other Access DBs, but what are they best used for? What are their limitations? Advantages? Is SQL handled the same? Same syntax? What is a "query" vs. a "table" in an ADO recordset? I've just started dabbling and want to do some general reading.

[ajetrumpet]

I don't know any general reading in terms of textbooks, but I can tell you that I've published an article on the differences. You can read that here: http://www.databasedev.co.uk/ado_vs_dao.html

Other than that, I'm not sure.