Why do I get 80040E24 errors?

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 forward-only; 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.