ADO » Stream » Open
Version: 2.5
- Syntax:
- streamobject.Open Source, Mode, OpenOptions, UserName, Password
- 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.
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.
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 |
Examples
Code:
objStream.Open rsGuruData, adModeReadWrite
objStream.Position = 0
...
objStream.Close
See Also:
