ADO offers some additional advanced features that you should keep in your arsenal of techniques. These include the capability to create a recordset without a data source, to work with persisted recordsets, to work with hierarchical recordsets, and to handle ADO events. The sections that follow cover these techniques.
Sometimes you will want to build your own cursors without connecting to a data source. An example is a scenario in which you want to use the rich ADO cursor engine to programmatically manipulate the files in a directory. Listing 10.23 provides an example.
Sub NoDataSource() Dim strFileName As String ...