Business solutions Automating Microsoft

16. Retrieving Data with ADO

IN THIS CHAPTER

What’s ADO and Why Do You Need It?

Using the ADO Connection Object

Working with Command Objects

Understanding the Different Types of Recordsets

Creating and Opening a Recordset

Filtering Recordsets

Using the Recordset Property

What’s ADO and Why Do You Need It?

The data you enter into an Access database isn’t actually stored in the database objects. Forms, tables, reports, and even queries are just interface objects by which you input, view, and retrieve data. Fortunately, Access handles the data exchange behind the scenes—you don’t need to know what’s going on or even that it is going on. You benefit from the process, regardless.

Things get a bit more complicated when you start using code to ...