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.
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.
For more information about the enumerations mentioned in the following tables, see "The ADO Enumerations" section later in this appendix.
Connection object represents a unique session to a particular data source. The
Connection object has collections, methods, and properties associated with it.
The following table describes each of the properties of the
Generic property indicating one or more characteristics of the
Configures the ...