I am having a problem using ADO. Sometimes when I open a recordset using ADO I get the recordcount as -1. I open a recordset in the following way:
rs.open "select * from account",cn,<adopendynamic> or <adopenstatic> ,adlockoptimistic
when I check the recordcount it shows -1. There are records in the recordset.
As far as I know, whenever records are returned in the recordset the recordcount property contains for the total count of records.

Whenever it shows -1, I am not able to use the properties in the recordset
i.e. Recordcount, movenext, movefirst etc. etc.
What could be the problem. Do you have any idea.

Regards,
Satish: