Hi,

I want to use the ADO Recordset Property: Recordset.Pagesize and 
Recordset.AbsolutePage to display records in multiple pages.

I received this error: 
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support bookmarks. This may be a limitation of 
the provider or of the selected cursortype.


I checked Recordset.Supports(adApproxPosition) and recordset.Supports
(adBookmark), and they both return false.

My server information are:
SQL server 2000 
IIS is 5.0
ADO 2.7


would anybody show me how to configure the ADO or any server side objects 
that it will support the bookmark and page break?	   	

Your help is very appreciated.

Thanks,

Lily Dang

Sorry if this is too late,
   I have had similar problems.  Change the cursor location of your 
connection object to adUseClient (or 3 if you have not included 
adovbs.inc).  The cursor that is provided by OLEDB and ADO sometimes 
supports features that are not supported by SQL Server.

Example

dim Conn 
set Conn = Server.CreateObject("ADODB.Connection")

Conn.CursorLocation = adUseClient 
Conn.Open "ConnectionString"

or

Conn.CursorLocation = 3  'if you are not including adovbs.inc 
Conn.Open "ConnectionString"