Description of Using Multiple Recordsets with a Single Database Connection :
In this article the author comes with a short method by building a Macro to open a database connection to a data source, recordset creation and query execution. The author illustrates how to build multiple recordsets to execute different queries with one simple connection to the database object. The sample source code is available.
ASP
