Returns the number of records in the rersult set
•For forwardonly recordsets the current record number is returned.
•For recordsets that return an 'Indetermined' value (-1) the server will actually 'count' the number of records, which may be slow.
Please use this access with care in these situations
The RecCount of an Ado Recordset is the number of rows in the recordset. This may differ from the actual number of rows on the server if a where clause or a join is used to retrieve the results.