W3Schools.com

ADO Open Method

Record Object Reference Complete Record Object Reference

The Open method opens an existing Record object or creates a new file or directory.

Syntax

Open(source,actconn,mode,createopt,opt,username,psword)

Parameter Description
source Optional. The source parameter may be one of the following:
  • An absolute url
  • A relative url
  • An open Recordset
  • Another Record object
  • A Command object
  • An SQL SELECT statement
  • A table name
actconn Optional. A connection string or a Connection object
mode Optional. A ConnectModeEnum value, that indicates the access mode of the Record object. Default is adModeUnknown
createopt Optional. A RecordCreateOptionsEnum value, that indicates whether an existing file/directory should be opened, or a new file/directory should be created. Default is adFailIfNotExists. This parameter will be ignored if the source parameter is not a URL
opt Optional. One or more RecordOpenOptionsEnum values, that specifies the options for opening the Record. Default is adOpenRecordUnspecified
username Optional. A user ID that authorizes access to source
psword Optional. A password that verifies the username

Example

Example 1: source as the URL of a folder:

set rec = Server.CreateObject("ADODB.record")
rec.Open("http://www.w3schools.com/ado/")

Example 2: source as a relative URL in a Connection object:

set conn=Server.CreateObject("ADODB.Connection")
set rec = Server.CreateObject("ADODB.record")
conn.Open "URL=http://www.w3schools.com/ado/"
rec.Open("test.doc", conn)

Example 3: source as a row in a Recordset object:

set rs = Server.CreateObject("ADODB.recordset")
set rec = Server.CreateObject("ADODB.record")
rs.Open "test.doc", "URL=http://www.w3schools.com/ado/",,,adCmdTableDirect
rs.MoveLast() 
rec.Open(rs) 

ConnectModeEnum Values
Constant Value Description
adModeUnknown 0 Default. 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

RecordCreateOptionsEnum Values
Constant Value Description
adFailIfNotExists -1 Default. Fails if the source parameter points to a node that not exists
adCreateNonCollection 0 Creates a new Record of type adSimpleRecord
adCreateCollection 0x2000 Creates a new Record specified by the source parameter. If it points to an existing node, an error will occur. To prevent the error combine this value with adOpenIfExists or adCreateOverwrite
adOpenIfExists 0x2000000 If the source points to an existing node or Record object, then the provider must open the existing Record instead of creating a new one. This value cannot be used with adCreateOverwrite
adCreateOverwrite 0x4000000 If the source points to an existing node or Record, then the existing Record will be overwritten and a new one is created in its place. This value cannot be used with adOpenIfExists
adCreateStructDoc 0x80000000 Creates a new Record of type adStructDoc

RecordOpenOptionsEnum Values
Constant Value Description
adOpenRecordUnspecified -1 Default. No options are specified
adOpenAsync 0x1000 Opens the Record object in asynchronous mode
adDelayFetchStream 0x4000 The default stream associated with the Record need not be retrieved initially
adDelayFetchFields 0x8000 The fields associated with the Record need not be retrieved initially, but can be retrieved at the first attempt to access the field
adOpenExecuteCommand 0x10000 The source contains command text that should be executed
adOpenOutput 0x800000 If the source points to a node that contains an executable script, then the opened Record will contain the results of the executed script. This value is only valid with non-collection records

Record Object Reference Complete Record Object Reference
W3Schools Certification

W3Schools' Online Certification

The perfect solution for professionals who need to balance work, family, and career building.

More than 10 000 certificates already issued!

Get Your Certificate »

The HTML Certificate documents your knowledge of HTML.

The CSS Certificate documents your knowledge of advanced CSS.

The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.

The jQuery Certificate documents your knowledge of jQuery.

The XML Certificate documents your knowledge of XML, XML DOM and XSLT.

The ASP Certificate documents your knowledge of ASP, SQL, and ADO.

The PHP Certificate documents your knowledge of PHP and SQL (MySQL).

WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
Download XML Editor
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE