Mode

Syntax

ConnectModeEnum = connectionobject.Mode

connectionobject.Mode = ConnectModeEnum

Description

Sets or returns the provider access permission (the ConnectModeEnum value) for a Connection object.

The Mode property dictates the provider access permissions for an open connection. It must be set before the connection is opened. This property sets or returns the ConnectModeEnum value. The default is adModeUnknown or zero.

ConnectModeEnum Constants

Constant	Value	Description
adModeUnknown	0	Permissions cannot be set or determined
adModeRead	1	Read-only
adModeWrite	2	Write-only
adModeReadWrite	3	Read and write permissions
adModeShareDenyRead	4	Prevents other connections from having read permissions
adModeShareDenyWrite	8	Prevents other connections from having write permissions
adModeShareExclusive	12	Prevents opening other connections
adModeShareDenyNone	16	Permits opening other connections with read/write permissions
adModeRecursive	0x400000	Used in conjunction with the *ShareDeny* constants to set permissions on sub-records

See Also

Connection, Record.Mode, Stream.Mode.

Example

Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Mode = adModeRead
objRecordset.IsolationLevel = adXactIsolated
...
objConnection.Open strConnect