SHARE THIS PAGE

ADO Tutorial

ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up

ADO Objects

ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes
ADO Summary

ADO Examples

ADO Exam

ADO Certificate

ADO Mode Property

Complete Connection Object Reference

The Mode property sets or returns a ConnectModeEnum value that indicates the permission for modifying data in a Connection, Record, or Stream object. This property is read/write when an object is closed, and read-only when an object is open.

Connection object - Default is adModeUnknown
Record object - Default is adModeRead
Stream object - Default is adModeRead or adModeUnknown

Note: This property can be set only when the Connection object is closed.

Syntax

object.Mode

Example

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Mode=adModeReadWrite
conn.Open(Server.Mappath("northwind.mdb"))

response.write(conn.Mode)

conn.Close
%>

ConnectModeEnum

Constant	Value	Description
adModeUnknown	0	Permissions have not been set or cannot be determined.
adModeRead	1	Read-only.
adModeWrite	2	Write-only.
adModeReadWrite	3	Read/write.
adModeShareDenyRead	4	Prevents others from opening a connection with read permissions.
adModeShareDenyWrite	8	Prevents others from opening a connection with write permissions.
adModeShareExclusive	12	Prevents others from opening a connection.
adModeShareDenyNone	16	Allows others to open a connection with any permissions.
adModeRecursive	0x400000	Used with adModeShareDenyNone, adModeShareDenyWrite, or adModeShareDenyRead to set permissions on all sub-records of the current Record.