This version provides richer user navigation but 'relies on RecordCount and PageCount, which negate 'the benefits of specifying a CacheSize for a 'Server-side cursor. 1 Then Response. If Not rst. EOF Then Response. This method is very efficient when specifying a CacheSize 'and using a Server-side cursor, because it does not 'use RecordCount and PageCount.
User experience is sacrificed.
1 Then Response. If If Not rst. EOF Then Response. Cursor location matters. If you use a client-side cursor, all the records will be read each time you open the recordset.