I&#039m trying to page (page 1 of N) query results from my SQL server. I have code that works with Access, but not SQL. It uses rs.AbsolutePage and rs.PageSize. I am accessing the SQL database with a view:<BR><BR>Set cmd = Server.CreateObject("ADODB.Command")<BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR><BR>cmd. ActiveConnection = Session("conRUSH")<BR>cmd.CommandType = 4<BR>cmd.CommandText = "NewStockList"<BR><BR>Set rs = cmd.Execute<BR><BR>--------<BR><BR>When the script hits the rs.AbsolutePage line, I get this error:<BR><BR>ADODB.Recordset error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>----------<BR><BR>Can anyone tell me how to accomplish the same affect (getting the total number of pages to display based on a records-per-page criteria) with the above code? I have to use the SQL view "NewStockList" to do the query. Thanks.<BR><BR>Aaron