O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required