The ADO Object Model
Remember when we examined the DAO Object model? It was quite a bit more involved than the ADO object model. We'll take a look at the ADO object model, then write a quick program that examines the various parts of the structure. Here's a graphic summarizing the model:
Here's how what we do with our code relates to the figure: Once we open a Connection to the database, we will then create a Recordset with that connection. From the Recordset, we will access the Fields Collection and, through it, the fields of the database.
We will write a simple program that shows each of these components of the ADO object model. But let's review the model first. This way, we can refer to the model as we write our program.