ASP Paging Error

[AtomicChip]

I'm trying to include paging in my asp page and everything works fine up until I try to set the recordset's absolute page property. When I try, I get the following error:

ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

Here is the code for the recordset:


rs2.pagesize = pgSize
rs2.cachesize = pgSize
rs2.open "SELECT * FROM purch_products WHERE product_type = '" & rs.fields("type_id&quot & "';",con
pgCount = rs2.pagecount

'and then the error pops up here:
rs2.absolutepage = pgCurrent

Any suggestions? -----------------------------------------------
"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy

 

[rac2]

Did you specify CursorType? Access and SQL Server support bookmarks but some databases do not.


rs2.CursorType = 1 'adOpenKeySet
or
rs2.CursorType = 3 'adOpenStatic