DAOTABLE: Uses MFC DAO Classes to Create Common Database Objects

Click to open or copy the DAOTABLE project files.

The DAOTABLE sample demonstrates using the MFC Data Access Objects (DAO) database classes to create common database objects: databases, tables, queries, fields, and indexes. This dialog-based application maps the properties of these objects to controls the user can set and/or view. The source code is organized so that most of the database interaction is isolated from the user-interface code. This makes it easy to identify examples of how one can use the MFC DAO database classes.

In addition to demonstrating the use of the MFC DAO classes, this sample can be a useful tool for creating simple Microsoft Access databases. You can create .mdb files from scratch, create and delete tables and queries, add and delete fields and indexes in the tables, and modify existing queries.

Running the Sample

DAOTABLE provides a detailed help facility to answer questions about the design, intent, and use of the program. Every dialog box has a help button that displays help for the controls on that dialog box. Additionally, there is a general information section accessible through the Help Contents button.

The MFC DAO classes are documented in Visual C++ ® Books Online. Simply search for the desired class (MFC DAO classes use the prefix "Cdao" as in CDaoTableDef), or the DAO property or method in which you are interested.

For additional documentation on DAO independent of the MFC classes, refer to the DAO Help available by installing the DAO Software Development Kit (SDK) from the Visual C++ CD-ROM disk.