Stream object (ADO)
Applies to: Access 2013, Office 2013
Represents a stream of binary data or text.
In tree-structured hierarchies such as a file system or an email system, a Record may have a default binary stream of bits associated with it that contains the contents of the file or the email. A Stream object can be used to manipulate fields or records containing these streams of data. A Stream object can be obtained in these ways:
From a URL pointing to an object (typically a file) containing binary or text data. This object can be a simple document, a Record object representing a structured document, or a folder.
By opening the default Stream object associated with a Record object. You can obtain the default stream associated with a Record object when the Record is opened, to eliminate a round-trip just to open the stream.
By instantiating a Stream object. These Stream objects can be used to store data for the purposes of your application. Unlike a Stream associated with a URL, or the default Stream of a Record, an instantiated Stream has no association with an underlying source by default.
With the methods and properties of a Stream object, you can do the following:
Open a Stream object from a Record or URL with the Open method.
Close a Stream with the Close method.
Write any Stream data still in the ADO buffer to the underlying object with the Flush method.
Copy the contents of a Stream to another Stream with the CopyTo method.
Specify the character set used for storing the Stream with the Charset property.
Halt an asynchronous Stream operation with the Cancel method.
Determine the number of bytes in a Stream with the Size property.
Control the current position within a Stream with the Position property.
Determine the type of data in a Stream with the Type property.
Determine the current state of the Stream (closed, open, or executing) with the State property.
Specify the access mode for the Stream with the Mode property.