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 consists of a number of objects. Here’s where to find information about each object type:
To simplify locating the article(s) that discuss a particular topic area, use the following table:
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 |
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.