F. Scott Barker's Microsoft® Access 2000 Power Programming

LOOKING AT THE OBJECT MODELS

That's right, object models, plural. Unlike DAO, which consists of one object model (see Figure 6.1), ADO has three separate object models.

Figure 6.1. The DAO object hierarchy starts with DBEngine, through which all other objects must be referenced.

ADO's object models work together to give you the objects and collections necessary to work with your data. The three object models consist of

• ActiveX Data Objects 2.1 (ADODB) let you create and work with recordsets, as well as perform error handling.

• ADO Extensions 2.1 for DDL and Security (ADOX) is the data definition language, allowing you to work with and modify the ...