ADO Mode Property

## 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 Examples

# ADO Mode Property

Complete Record 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.

Complete Record Object Reference

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE