Microsoft OLE DB Provider for SQL Server error '80040e24'
Rowset does not support fetching backward.
or
Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
Rowset does not support fetching backward.
or
Microsoft JET Database Engine error '80040e24'
Rowset does not support fetching backward.
If you are attempting to use MovePrevious or MoveLast, consider changing your ORDER BY statement to reflect the
order in which you want to process records. All recordsets being written out to ASP should be processed forwardonly;
if you absolutely need to move backwards, consider creating an array using GetRows(), and traverse the array
in reverse order. If you are only interested in the last record, reverse your ORDER BY and use SELECT TOP 1 in your
SELECT query.
If you are attempting to get the RecordCount, see KB #246636 for a potential explanation, and Article #2193 for
alternative methods.
If you've set the cursorType of an ADODB.Recordset, you should re-consider whether you need a recordset object
with special properties (see Article #2191) and, if so, make sure you include the appropriate constants from
ADOVBS.inc (see Article #2112).
For further information, see KB #306385 and KB #306388.
   _{Your Comment}