Alison Balter's Mastering Access 2002 Enterprise Development

Advanced ADO Techniques

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.

Creating Recordsets Without a Data Source

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.

Listing 10.23. Creating a Cursor Without Connecting to a Data Source

Sub NoDataSource() Dim strFileName As String ...