O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey 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

E.1. Connection Object

The Connection object represents a unique session with a data source. The Connection object has collections, methods, and properties associated with it. The availability of these collections, methods, and properties is dependent on the functionality supported by the provider.

E.1.1. Properties of the Connection Object

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

PropertyDataTypeDescription
AttributesLongGeneric property indicating one or more characteristics of the connection object.
CommandTimeoutLongConfigures the timeout value for the Execute method on the Connection object.
ConnectionStringStringThe default property value. Specifies a data source. Pass in a connection string containing a series of argument = value statements separated by semicolons.
ConnectionTimeoutLongIndicates how long to wait while establishing a connection before terminating the attempt and generating an error.
CursorLocationLongAllows the developer to choose between various cursor locations (usually either client or server).
DefaultDatabaseStringSets or returns a string that resolves to the name of a database available from the provider.
IsolationLevelLongSets or returns an IsolationLevelEnum value. The default is adXactReadCommitted.
ModeLongIndicates the level of permissions available for modifying data in a connection, record, or stream object.
ProviderStringSets or returns a string value representing the provider name. If no provider is specified, ...

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