The ADO Object Model

The ADO object model provides a quick, yet powerful, interface to access data from a database. The ADO model is illustrated below:

The ADO Object Model

This diagram displays all the objects that comprise the ADO hierarchy. There are three major objects that let you directly interface with your data:

• Connection

• Command

• Recordset

The Connection Object is the main backbone of your data. You can think of the Connection Object as the pathway to your data source. Without the Connection Object you would have no way to connect to your data source. The Connection Object contains the Errors Object, which logs all the errors that occur in your Connection Object. The Command Object is optional, but is still important to ADO. The Recordset Object expands the access to the data. All three objects are explained in greater detail in the following chapters.