ADO » Connection » Mode
- Syntax:
- ConnectModeEnum
= connectionobject.Mode
connectionobject.Mode = ConnectModeEnum
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 |
Examples
Code:
Set objConnection = Server.CreateObject("ADODB.Connection")
objConnection.Mode = adModeRead
objRecordset.IsolationLevel = adXactIsolated
...
objConnection.Open strConnect
See Also:
