Chapter 27. Understanding the Data Access Object Class
Access VBA lets you create and manipulate databases, tables, and queries using the Jet 3.5 database engine. Access 97 also offers a new alternative to the full-feature Jet 3.5 engine: ODBCDirect, which uses the Remote Data Object (RDO) version 2.0 for connecting to client/server databases. This chapter introduces you to the many data access object (DAO) classes of Jet 3.5 and explains how you can manipulate the DAOs with Access VBA code. The chapter also describes how to use ODBCDirect, which is accessible only with VBA code.
No Data Access Object exists, per se; the term refers to all collections of Access 97 objects. The structure of the hierarchy of DAO classes was, to a major extent, ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
