ADODB Object
 
Syntax
 
ConnectModeEnum = recordobject.Mode
recordobject.Mode = ConnectModeEnum
 
Description
Sets or returns the provider access permission (the ConnectModeEnum value) for a Record 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.
 
 
ConnectModeEnum Constants 
 
Constant
Value
Description
adModeRead
1
Read-only permission
adModeReadWrite
3
Read/write permission
adModeRecursive
0x400000
Sets permissions for children of the Record. Must use with either adModeShareDenyRead or adModeShareDenyWrite. Or must use with adModeShareDenyNone plus any one of adModeRead, adModeReadWrite, or adModeWrite
adModeShareDenyNone
16
Other users can open a connection with all permissions
adModeShareDenyRead
4
No other user can open a connection with read permission
adModeShareDenyWrite
8
No other user can open a connection with write permission
adModeShareExclusive
12
No other user can open a connection
adModeUnknown
0
Default, permission not set or determined
adModeWrite
2
Write-only permissions
See Also
Connection.Mode, Stream.Mode.
Example
 
objRecord.Mode = adModeRead
...
objRecord.Open strSourceURL