i have created a recordset say rs and it has a valid connection as well as a valid sql string

rs.open sql,con,adopenkeyset,adlockpessimistic

Why is it so that the recordcount method returns the total no. of records correctly in this case,
But returns -1 with other locktypes and cursor types?
with Regards
Vbgirl