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.