O'Reilly logo

Microsoft® Access® 2010 Programmer's Reference by Jerry Dennison, Geoffrey L. Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required