O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

E.10. Stream Object

The Stream object in ADO represents a stream of binary data or text. Although the Stream object was not covered in the chapter for ADO, it is included here for reference. Be aware that not all ADO providers support the Stream object.

E.10.1. Properties for the Stream Object

The following table lists the various properties of the Stream object.

PropertyDataTypeDescription
CharsetStringSpecifies the character set for the stream.
EOSBooleanTrue if the current position is at the end of stream (EOS).
LineSeparatorLineSeparatorEnumSpecifies the character or combination of characters used as the line separator in the stream.
ModeConnectModeEnumSpecifies the permissions for modifying data in the Stream object.
PositionLongThe current position in the stream.
SizeLongSpecifies the current size of the stream of data.
StateObjectStateEnumSpecifies the current state of the Stream object.
TypeStreamTypeEnumSpecifies the type of data stored in the Stream object.

E.10.2. Methods for the Stream Object

The methods you can use with the Stream object are described in the following table.

MethodDescription
CancelCancels a pending asynchronous call to a Stream object.
CloseCloses an open Stream object.
CopyToCopies data from the Stream object to another Stream object.
FlushFlushes the contents stored in the Stream's buffer.
LoadFromFileLoads the contents of a file into the Stream object.
OpenOpens the Stream object.
ReadReads binary data from the stream.
ReadTextReads text data from the stream. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required