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

Get Microsoft® Access® 2010 Programmer's Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.