1. Home

ADO Mode Property

The Mode property sets or returns a ConnectModeEnumvalue 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."

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.

❮ Complete Record Object Reference

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US