ADO`s Stream Object - How to open a Stream object using ADO (Page 2 of 6 )
Since the Stream object's content is in the record object, the Stream object can be opened after opening a record object. We have also seen that the Record object can be opened using an already open recordset object. In this case the recordset object is really looking at an URL.
The Stream object can be opened without opening either the Record or recordset (followed by record) objects. It can be opened simply by supplying the URL as an argument. Another way of creating the Stream object is to open it in memory, which holds the contents of the Stream in memory, like a local buffer. This method will not require any arguments.
There are therefore at least four ways of opening the Stream object, and they will be illustrated by examples. Based on these different ways, the Stream object's relationship vis-à-vis the other objects should be as shown in this next picture (in earlier diagrams the Stream object is sitting all by itself).
Adding a reference to the ADO 2.8 library
The MS Access Application Stream is open in the visual basic editor. Go to Tools -->References... as shown in the next picture.
This brings up the References - stream window as shown. Here you use the scroll bar to scroll down and pick ADO 2.8. The default may be ADO 2.0. Now you can access all the properties and methods of all the ADO objects including the Stream object.
At this point you may be interested in all the different properties and methods of the Stream object. There is no better place look than the Object Browser.
Next: Syntax for opening a Stream >>
More Database Articles
More By Jayaram Krishnaswamy
