Extract from asp101:
There are five different recordset properties that are used to implement recordset paging:
CursorLocation :: In order to use recordset paging, you will need to set this value to "adUseClient".
PageSize :: Sets the number of records that the recordset will display on each page. A neat use of this is to allow the client to configure this setting so that they can tailor the recordset to their tastes.
PageCount :: After setting the recordset's PageSize, you can read this property to check how many pages are in the recordset.
AbsolutePage :: This property tells you what page you are on. You can set this property on the fly to jump to a different page in the recordset.
AbsolutePosition :: This property will tell you what record you are on. You can read this property, or write to it to jump to a specific record.
You can go through the full article here ::
http://www.asp101.com/articles/recor...ging/index.asp (it has code samples in it)
Best Regards
Vadivel
MVP ASP/ASP.NET
http://vadivel.thinkingms.com