Microsoft® Access® 2010 Programmer's Reference

Appendix C. ADO Object Model Reference

This appendix describes each of the ActiveX Data Objects (ADO) provided by the various ADO object models available in Access 2010. The ActiveX Data Objects (ADO) Object Model was designed to allow data access for a wide variety of data formats. The ADO object model isn't overly complicated and can be implemented quite easily in your VBA code. Descriptions of each of the ADO objects, properties, methods, and associated collections have been provided.

Note

The availability of each collection, event, method, and property is dependent on the functionality supported by each particular ADO data provider. Not all objects are supported by every provider, and functionality may be slightly different depending on the exact version of ADO being used. This section will primarily address Microsoft's Object Linking and Embedding Database (OLE DB) provider for ACE in Access 2010.

Note

For more information about the enumerations mentioned in the following tables, see "The ADO Enumerations" section later in this appendix.

THE CONNECTION OBJECT

The Connection object represents a unique session to a particular data source. The Connection object has collections, methods, and properties associated with it.

Properties of the Connection Object

The following table describes each of the properties of the Connection object.

PROPERTY	DATA TYPE	DESCRIPTION
Attributes	Long	Generic property indicating one or more characteristics of the Connection object.
CommandTimeout	Long	Configures the ...