ADO » Record » Open

Version: 2.5

Syntax:
recordobject.Open Source, ActiveConnection, Mode, CreateOptions, Options, UserName, Password
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.

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.

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

Examples

Code:
Set objRecord = Server.CreateObject("ADODB.Record")
objRecord.ActiveConnection = strConnection
...
objRecord.Open strSourceURL
Code:
Set objRecord = Server.CreateObject("ADODB.Record")
...
objRecord.Open strSourceURL, strConnection

See Also: