ADO Open Method


❮ 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("https://www.w3schools.com/asp/")

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=https://www.w3schools.com/asp/"
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=https://www.w3schools.com/asp/",,,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

❮ Complete Record Object Reference
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.