Why RS.AbsolutePage is not supported?

Posted on 2000-02-16
Medium Priority
Last Modified: 2008-03-17
I'm using DSN-less Access database.
This error occurs when the following line is added to the code.

objPagingRS.AbsolutePage = iPageCurrent


ADODB.Recordset error '800a0cb3'

The operation requested by the application is not supported by the provider.

Pls advise why this application is not supported and any way to rectify it?
Question by:qiang8
LVL 19

Accepted Solution

daveamour earned 40 total points
ID: 2526639
It may be that you are using the wrong type of cursor for your recordset.  I beleive that certain cursor types do not support the AbSolutePage property.

For example the following line uses a Forward only cursor

rs.Open strSQL, objADO_ComInfo, adOpenForwardOnly, adLockPessimistic, adCmdText

There are other types of cursors available as follows


Try changing the cursor to a different type.  For example to change to a Statit cursor you would use

rs.Open strSQL, objADO_ComInfo, adOpenStatic, adLockPessimistic, adCmdText

Note that these names are constants which are declared in ADOVBS.INC so if you do not have this file included in your asp page then refer to the cursors by number rather than name.  The numbers are as follows

adOpenForwardOnly..... 0
adOpenKeyset.......... 1
adOpenDynamic......... 2
adOpenStatic.......... 3

So again to open a recordset with a static cursor referring to it by number you would use this

rs.Open strSQL, objADO_ComInfo, 3, adLockPessimistic, adCmdText

Hope this helps



Author Comment

ID: 2526681
Thanks a lot. It is due to improper use of cursor type.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming…
There is a wide range of advantages associated with the use of ASP.NET. This is why this programming framework is used to create excellent enterprise-class websites, technologies, and web applications.
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question