DAO: Database Tasks

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...