Special Edition Using Access 97, Second Edition

Creating New Data Access Objects

As mentioned in the section Creating Object Variables earlier in this chapter, Access 97 lets you create new DAOs with Access VBA code. The most common DAOs you create with Access VBA are Recordset and QueryDef objects. QueryDef objects, like TableDef objects, are called persistent objects because QueryDef and TableDef objects also are Document objects: Query and Table objects, respectively. QueryDef and TableDef objects are stored as elements of your .mdb file and appear in the Queries and Tables lists, respectively, of the Database window. Recordset objects are impersistent objects; they exist in memory only from the time you open them until they are closed. You can close a Recordset object by applying the ...