You use ADODB?
the cursor may be on the client side
rs.cursorlocation=aduseclient
rs.cachesize=100
rs.CursorType = adOpenStatic
rs.LockType = adLockReadOnly
rs.open mySQL,connectme
rs.pagesize= nb of rows wanted
(number of pages)=cint(rstemp.pagecount)
rs.absolutepage= (position of the page)

You better check this to have the complet example
[url]http://www.learnasp.com/learn/dbtablepaged.asp[/url]