How can I display groups of records (for example, the first 10 records), then allow the user to click Next to display the next set of records? I have tried leaving the resultset/connection open, but I can't seem to reattach to it.
You cannot reuse the recordset efficiently. Your best way out is to program your SQL retrieval code so that it only brings back the records you need, by passing some sort of a begin or end marker. So the first time you ask for Record 1 plus the next nine records. The next time, you ask for a set of records beginning at Record 10 and so on.