Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days

Using the Recordset Object

The Recordset object is a collection of one or more records. A typical record would be the results of a SQL select from one or more tables in a database. But, it could also represent an email message or perhaps a file in a directory. The Recordset object is the primary object you will be using in ADO. You will become (and want to become) familiar with the different methods and properties of this object. You will pass these objects back and forth between functions and methods; iterate through it to display information to a user and add information to it to eventually save it to the database. And that's only the start! I might sound like a salesman here, but really this is the star in the ADO family. You will be using ...