DATA ACCESS OBJECT(DAO)

Ø Definition:A DAO database object, represented in MFC by class, represents a connection to a database through which you can operate on the data. You can have one or more CDaoDatabase objects active at a time in a given workspace, represented by an object.

Ø Besides using to work with Microsoft Jet (.MDB) databases, you can also access external data sources, particularly Open Database Connectivity (ODBC) data sources.

Ø In DAO:

·        Each workspace object contains a collection of open database objects, called the Databases collection.

·        Each DAO database objects contains collections of tabledefs, querydefs, recordsets, and relations.

Ø Role of Database:

·        Create new Microsoft Jet (.MDB) database files.

·        Store tabledef objects that you can use to manipulate the structure of the database’s tables.

·        Store querydef objects so you can reuse the queries they represent later.

·        View and manipulate data in the database’s tables.

·        Work with data in local or remote databases.