DAO: Database Tasks

OverviewHow Do IFAQSampleODBC Driver List

This article points you to other articles about performing common database tasks. The following table lists the tasks and articles.

Articles About Common Database Tasks

For information about... See...
Applications Writing a database application DAO: Writing a Database Application
Accessing the database engine DAO Workspace: Accessing Properties of the Database Engine
DAO Workspace: The Database Engine
Creating Objects Creating DAO objects DAO: Creating, Opening, and Closing DAO Objects
Opening Objects Opening DAO objects DAO: Creating, Opening, and Closing DAO Objects
Closing Objects Closing DAO objects DAO: Creating, Opening, and Closing DAO Objects
Collections (DAO) Accessing collections DAO Collections
Obtaining information about objects in collections DAO Collections: Obtaining Information About DAO Objects
Databases Creating an .MDB database DAO Database
Examining the schema of a database DAO Tabledef
DAO Tabledef: Examining a Database Schema at Run Time
Working with multiple databases DAO Workspace
ODBC Working with ODBC data sources DAO External: Working with External Data Sources
Queries
Recordsets
Selecting records DAO Queries
DAO Recordset
DAO Recordset: Creating Recordsets
DAO Queries: Filtering and Parameterizing Queries
Binding records dynamically DAO Recordset: Binding Records Dynamically
Updating records DAO Recordset: Recordset Operations
Defining stored queries DAO Querydef
Navigating in a recordset DAO Recordset: Recordset Navigation
Record Field Exchange Using DFX to exchange data between the database and a recordset's field data members DAO Record Field Exchange (DFX)
Moving data between a recordset and the controls on a form Dialog Data Exchange and Validation
SQL Using SQL with DAO DAO Queries: SQL for DAO
Tables Adding or deleting a table DAO Tabledef: Using Tabledefs
Adding or deleting a table field DAO Tabledef: Using Tabledefs
Adding or deleting a table index DAO Tabledef: Using Tabledefs
Transactions Managing database transactions DAO Workspace: Managing Transactions
DAO Workspace: Opening a Separate Transaction Space

See Also   DAO: Where Is...