ADO task table

Applies to: Access 2013, Office 2013

The following table lists programming tasks contained in the ADO programmer's guide and provides references for each task. These references can be textual descriptions or code examples in which you can find information about the ADO feature that performs the task.

ADO task	References
Connecting to a data provider	Making a Connection
Executing commands or calling stored procedures	Using the Command Object
Opening a Recordset	The Recordset Object Open Method
Determining the size of a Recordset	Counting Rows and The Limits of a Recordset
Moving to a specific record	Navigating Through the Data
Accessing column values	The Fields Collection
Searching for data	Working with Recordsets
Modifying data and changing values	Editing Existing Records
Adding new data	Adding Records
Deleting or removing data	Deleting Records Using the Delete Method
Posting changes to the data source	Updating Data
Beginning, committing, and rolling back transactions	Transaction Processing
Saving records to a file (XML or binary)	Persisting Data
Handling errors	ADO Errors
Handling events, asynchronous programming	ADO Event Handler Summary
Choosing cursor location and type	Types of Cursors
Choosing lock types	Types of Locks
Returning related records in a Recordset	Data Shaping
Accessing semi-structured data	Chapter 10: Records and Streams
Publishing to IIS	Using ADO for Internet Publishing