DAO: Where Is... (MFC)

DAO: Where Is...

Visual C++ Concepts: Adding Functionality

DAO: Where Is...

This article will help you locate topics of interest in the MFC DAO documentation and in the DAO Help topics. This article is organized as follows:

DAO Overviews
DAO Objects
Information By Topic
Key DAO Help Topics

Documentation for the MFC DAO classes consists of two components:

MFC-specific: MFC classes in the MFC Reference and MFC conceptual articles. The articles all begin with the "DAO" prefix.
DAO-specific: Topics from the DAO Help files shipped with products such as Microsoft Office. These topics have been incorporated into the online documentation, but note that they are oriented toward the Basic programming language. They are included to provide DAO-specific details in areas where MFC neither modifies nor adds to DAO functionality.

DAO Overviews

For overviews and general information about MFC DAO, see:

DAO Objects

DAO consists of a number of objects. Here's where to find information about each object type:

Where to find information about DAO objects

DAO Help topics	MFC class	MFC Help topics
Database Object	CDaoDatabase	DAO Database
Error Object	CDaoException	CDaoException
Querydef Object	CDaoQueryDef	DAO Querydef
Recordset Object	CDaoRecordset	DAO Recordset
Tabledef Object	CDaoTableDef	DAO Tabledef
Workspace Object	CDaoWorkspace	DAO Workspace

Information By Topic

To simplify locating the article(s) that discuss a particular topic area | use the following table:

Where to look for...

Topic	Location
Action queries	DAO Querydef: Action Queries and SQL Pass-Through Queries
Adding records	DAO Recordset: Recordset Operations
Aggregate records	DAO Recordset: Using Aggregate SQL Functions with MFC DAO Classes
Application design options	DAO: Writing a Database Application
Attaching tables	DAO External: Working with External Data Sources
Buffering records	DAO Record Field Exchange: Double Buffering Records
Calling DAO directly	Can I Call DAO or ODBC Directly?
CDaoXInfo structures	DAO Collections: Obtaining Information About DAO Objects
Closing DAO objects	DAO: Creating, Opening, and Closing DAO Objects
Collections in DAO	DAO Collections
Console applications and DAO	DAO: Database Application Design Options
Creating DAO objects	DAO: Creating, Opening, and Closing DAO Objects
DAO objects not mapped to classes	DAO and MFC
DAO vs. ODBC	Should I Use DAO or ODBC?
Data definition language (DDL)	Database Definition and Manipulation
Database engine (Jet)	DAO Workspace: The Database Engine
Data types	DFX Data Types in DAO Record Field Exchange: Using the DFX Functions
DBMS targets	DAO: Writing a Database Application What Data Sources Can You Access with DAO and ODBC?
Default workspace	DAO Workspace: Explicitly Opening the Default Workspace
Definition of DAO	What Are DAO and ODBC?
DLLs \| DAO in	DAO: Database Application Design Options DAO: Using DAO in DLLs
Document/view architecture	DAO: Writing a Database Application
Documentation	More Information About the DAO and ODBC Classes
Double buffering records	DAO Record Field Exchange: Double Buffering Records
Engine initialization	DAO Workspace: The Database Engine
External data sources \| list	DAO External: Working with External Data Sources
Filtering recordsets	DAO Queries: Filtering and Parameterizing Queries
Finding	DAO Recordset: Recordset Navigation
Forms	Record Views
How MFC encapsulates DAO	DAO and MFC
Installing DAO	Installing MFC Database Support
ISAM databases \| list	Database Topics (DAO)
Jet database engine	DAO Workspace: The Database Engine
Multithreading and DAO	DAO: Database Application Design Options
Navigating in a recordset	DAO Recordset: Recordset Navigation
ODBC data sources	DAO External: Working with External Data Sources
ODBC drivers	ODBC Driver List
ODBC vs. DAO	What Are DAO and ODBC? Should I Use DAO or ODBC?
ActiveX controls \| DAO in	DAO: Database Application Design Options
Opening DAO objects	DAO: Creating, Opening, and Closing DAO Objects
Parameterizing queries	DAO Queries: Filtering and Parameterizing Queries
Pass-through queries	DAO Querydef: Action Queries and SQL Pass-Through Queries
Performance	DAO External: Improving Performance with External Data Sources
Programming model	What Is the MFC Database Programming Model?
Queries	DAO Queries
Querydefs	DAO Querydef
Record Field Exchange (DFX)	DAO Record Field Exchange (DFX)
Recordsets	DAO Recordset
Scrolling	DAO Recordset: Recordset Navigation
Security	DAO and MFC
Seeking	DAO Recordset: Recordset Navigation
SQL	DAO Queries: SQL for DAO
Tabledefs	DAO Tabledef
Task-oriented topics	DAO: Database Tasks
Transactions	DAO Workspace: Managing Transactions
Updating data	DAO Recordset: Recordset Operations
Views of DAO data	DAO: Writing a Database Application
When to use database classes	When Should I Use the Database Classes?
Workspace \| typical scenario	DAO Database: Using Workspaces and Databases
Writing a database application	DAO: Writing a Database Application

Key DAO Help Topics

The following topics are part of DAO Help and are not MFC-specific. To use them | you must open the DAO SDK help file | which is not part of the online documentation.

Data Access Object Hierarchy
Data Access Objects and Collections Reference
Using Data Access
Trappable Data Access Errors
Microsoft Jet Database Engine SQL Data Types
Microsoft Jet Database Engine SQL Reserved Words
Equivalent ANSI SQL Data Types
SQL Aggregate Functions

DAO Overviews

DAO Objects

See Also

Information By Topic

See Also

Key DAO Help Topics