Indicates the current number of records in a Recordset object.
Return Values
Returns a Long value.
Remarks
Use the RecordCount property to find out how many records are in a Recordset object. The property returns adUnknown (-1) when ADO cannot determine the number of records. Reading the RecordCount property on a closed Recordset causes an error.
If the Recordset object supports approximate positioning or bookmarks, this value will be the exact number of records in the Recordset regardless of whether it has been fully populated. If the Recordset object does not support approximate positioning, this property may be a significant drain on resources because all records will have to be retrieved and counted to return an accurate RecordCount value.