ADODB Object
 
Syntax
 
streamobject.Open [Source][, Mode][, OpenOptions][, UserName][, Password]
 
Description
Opens a Stream object from a URL or Record object.
 
The Open method is called to open a Stream object. While the Open operation is occurring, you temporarily cannot set any properties until the open is completed. Remember, prior to opening a Stream, you can access the various read-only properties and obtain values.
 
There are five optional parameters.
 
Parameter
Description
Source
The optional Source parameter is a variant that indicates the source of the data for the Stream object. This can be a URL or a reference to an already opened Record object. If you do not specify a source, a new Stream will be created and opened. It will have a Size of zero and will contain no data since it will not be associated with any underlying source.
Mode
The optional Mode parameter is one of the ConnectModeEnum constants that dictate the access permissions for a Stream object. If the Source parameter is an already opened Record object, this parameter will be implicitly set.
OpenOptions
The optional OpenOptions parameter is a StreamOpenOptionsEnum constant that specifies possible options for opening a Stream object.
UserName
The optional UserName parameter is a string containing the name of a user who can access the Stream object. If the Source parameter is an already opened Record, neither the UserName nor the Password parameter is used.
Password
The optional Password parameter is a string containing the password that validates the UserName parameter. If the Source parameter is an already opened Record, neither the UserName nor the Password parameter is used.
 
 
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:
1. adModeShareDenyRead,
2. or adModeShareDenyWrite, 
3. or 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
 
  
StreamOpenOptionsEnum Constants 
 
Constant
Value
Description
adOpenStreamAsync
1
Open in an asynchronous mode
adOpenStreamFromRecord
4
Already opened Record
adOpenStreamUnspecified
-1
Use the default
See Also
Connection.Open, Record.Open, Recordset.Open, Stream.Close.
Example
 
objStream.Open rsData, adModeReadWrite
objStream.Position = 0
...
objStream.Close