Share this Page URL
Help

Part III: Working with Access Data > Retrieving Data with ADO - Pg. 237

Retrieving Data with ADO 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 interact with your data. That's where the ActiveX Data Objects (ADO) library comes into the picture. In a nutshell, ADO is an object model that provides a few specialized objects for retrieving data. ADO is your ticket to accessing all types of data, not just Access data. 16 IN THIS CHAPTER What's ADO and Why Do You Need It? . . . . .237 Using the ADO Connection Object . . . . . . . . .238 Working with Command Objects . . . . . . . . .242 Understanding the Different Types of Recordsets . . . . . . . . . . . . . . . . . . . . . . . . .244 Creating and Opening a Recordset . . . . . . . .245 Filtering Recordsets . . . . . . . . . . . . . . . . . . . .247 Using the Recordset Property . . . . . . . . . . . .248