>Hi All:
> How can I get the total number of records in a ADO record set like RecCount() in vfp. I have tried rs.RecordCount, but it returns -1. (rs is a record set)
>Thanks

Try using a Static recordset. Something like:

strConn = “Your connection string”
sString = “Select * from My table”

oRS.Open sString ,strConn,3,3

nORSRecords = oRS.Recordcount


Tom