Recordset.AbsolutePage - strange problem

I have a ASP page that fires a query to DB and displays records using
paging.
My code contains
rs.Open string1 , MyConn , 3,1

rs.PageSize=20
rs.AbsolutePage= CurPg
Problem with this code is, it load the page fine sometimes, on refresh give
me 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.

What could be the problem. This code was working perfectly till recent.
Can anyone help me troubleshooting when this can happen.

Records would not load at all if there was problem with the code. They do
load. But 2 times our of 5 gives me the above error

Please Help! It's Urgent

-Gauri


.

Relevant Pages

  • User Input in OnLoad Form Event
    ... The second form holds data fed from a query, ... The second form loads from the query. ... The list boxes in the second form requery on load. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access General Inquiry
    ... Form_BeforeUpdate for record validation, ... a table or query as datasource. ... Or the form would load with empty fields, ... datatable or query as a recordsource with wizard functionality built into ...
    (microsoft.public.access.forms)
  • Re: query speed
    ... If there aren't any rows in tbl_archive, just load the data w/o the LEFT ... duplicates (like your query), the 1st query always runs slowly (or not ... Ideally, I want this query to prevent records from being appended to tbl_archive if the record is already there for a loan acct # for that date and with that status is already there, but it is even slower, and I am not even sure if the syntax is even right to achieve this, as I got multiple same-records appended: ...
    (microsoft.public.access.queries)
  • RE: Lazy Loading Grid Object
    ... Yeah, I realize that I will be doing a "paging" type functionality, but make ... to an xml file and then running the grid from the local xml. ... row count and use to set the size, then when the user clicks on the scroll ... > as such you are going to have to load the whole lot or load it in sections ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Force Form to finish Loading before running Code
    ... I already use the Form Timer Event set to 1000 to provide a clock on the ... The import code contains a number of Do Events hoever the form wont load ... Dave Hargis, Microsoft Access MVP ... I want the query to run after the form has fully loaded. ...
    (microsoft.public.access.formscoding)