ADO: ActiveX Data Objects

Chapter 10. Records and Streams

The Record object represents either a single record of a Recordset object or of a resource on a web server (such as a file or a directory). The Stream object represents a buffer of either binary or text data.

Together the Record and Stream objects can be used to navigate hierarchical data sources, such as a directory structure. Each file and directory within this hierarchical data source is considered a resource and therefore can be opened as a Record object. The Record object allows you to copy, move, and delete files and directories of a data source. Within such a resource, there is a stream (or buffer) of information that can be read, thus the Stream object. The Stream object allows you to manipulate the contents of a stream by editing the text or binary data directly. One of the most interesting features about these two new objects is the ability to connect to their data source with the use of URLs as a connection string. Both the Record and Stream objects were introduced with ActiveX Data Objects 2.5.