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 UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO 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:
|
| 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)
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 |
Complete Record Object Reference
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
