ADODB Object
 
Syntax
 
recordobject.Open [Source][, ActiveConnection][, Mode][, CreateOptions][, Options][, UserName][, Password]
Description
Used to open an existing Record object, or to create a new file or directory.
The Open method is used to open an existing Record object or to create a new file or directory.
 
There are seven optional parameters.
 
Parameter
Description
Source
The optional Source parameter is a variant that is the absolute or relative URL of the entity represented by the Record, or it is a row of a Recordset object that is open.
ActiveConnection
The optional ActiveConnection parameter is a variant that is the connection string or an open Connection object which specifies the file or directory that the Record object will be applied. If this property is not specified and Source is an absolute URL, then a Connection object is implicitly created using Source. If Source is a relative URL, then ActiveConnection must contain a Connection object, an absolute URL, or a Record that represents a directory.
Mode
The optional Mode parameter is one or more of the ConnectModeEnum constants that declare the mode for the Record. The default is adModeUnknown.
CreateOptions
The optional CreateOptions parameter is one or more of the RecordCreateOptionsEnum constants that specify whether to open an existing Record or to create a new one. The default is adFailIfNotExists.
Options
The optional Options parameter is one or more of the RecordOpenOptionsEnum constants that specify the options for opening a Record object. The default is adOpenRecordUnspecified.
UserName
The optional UserName parameter is a string that is the user name of a person who has authorization to access the destination locale.
Password
The optional Password parameter is a string that is the password that authenticates the UserName parameter.
 
 
ConnectModeEnum Constants 
 
Constant
Value
Description
adModeRead
1
Read-only permission
adModeReadWrite
3
Read/write permission
adModeRecursive
0x400000
Sets permissions for children of the Record. Must use with either adModeShareDenyRead or adModeShareDenyWrite. Or must use with adModeShareDenyNone plus any one of adModeRead, adModeReadWrite, or adModeWrite
adModeShareDenyNone
16
Other users can open a connection with all permissions
adModeShareDenyRead
4
No other user can open a connection with read permission
adModeShareDenyWrite
8
No other user can open a connection with write permission
adModeShareExclusive
12
No other user can open a connection
adModeUnknown
0
Default, permission not set or determined
adModeWrite
2
Write-only permissions
 
 
RecordCreateOptionsEnum Constants 
 
Constant
Value
Description
adCreateCollection
0x2000
Create a new Record specified by Source parameter
adCreateNonCollection
0
Create a new Record of type adSimpleRecord
adCreateOverwrite
0x4000000
Allows overwrite of existing Record
. You must OR this constant with adCreateCollection, adCreateNonCollection, or adCreateStructDoc
adCreateStructDoc
0x80000000
Create a new Record of type adStructDoc
adFailIfNotExists
-1
Default
adOpenIfExists
0x2000000
Provider must open existing Record
. You must OR this constant with adCreateCollection, adCreateNonCollection, or adCreateStructDoc
 
 
RecordOpenOptionsEnum Constants 
 
Constant
Value
Description
adDelayFetchField
0x8000
Retrieve fields associated with Record only when needed
adDelayFetchStream
0x4000
Retrieve stream associated with Record only when needed
adOpenAsync
0x1000
Open in an asynchronous mode
adOpenRecordUnspecified
-1
Default, no options selected
adOpenSource
0x800000
Opens source of executable script
See Also
Connection.Open, Close, Recordset.Open, Stream.Open.
Example
 
Set objRecord = Server.CreateObject("ADODB.Record")
objRecord.ActiveConnection = strConnection
...
objRecord.Open strSourceURL
 
 
 
Set objRecord = Server.CreateObject("ADODB.Record")
...
objRecord.Open strSourceURL, strConnection