Why ADO Record Set cannot return [record count]?

[Sadayoshi Yumita]

ADO RecordSet Object cannot return [recordcount] value.
Anyone Knows about this?

[Rex Moore]

If you want to know the number of records in the recordset, you must change
one of the properties before the rst.open command:

rst.CursorLocation = adUseClient

Post by Sadayoshi Yumita
ADO RecordSet Object cannot return [recordcount] value.
Anyone Knows about this?

[Sadayoshi Yumita]

Thanks. I get the number of records in the recordset.

Post by Rex Moore
If you want to know the number of records in the recordset, you must change
rst.CursorLocation = adUseClient

Post by Sadayoshi Yumita
ADO RecordSet Object cannot return [recordcount] value.
Anyone Knows about this?