View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default ADO recordset returns -1

Philip wrote ...

the default CursorLocation is server-side (adUseServer) with forward only
cursors.


Yes, but you can specify something other than the default!

To navigate ADO recorsets, and get information like "Recordset.Count" or
"Recordset.AbsolutePosition" you need to explicitly set it to adUseClient


Incorrect. Availability of such properties is determined by cursor
type, not location. Any cursor type other than 'forward only' will
support the RecordCount property.

get information like "Recordset.Count"


The Recordset object does not have a Count property.

Jamie.

--