Recordcount Returns -1

I am using ADO and wanted to get the number of records in a result set. I use SQL SERVER 7.0. But everytime I issuse the command RecordCount, it always return -1 eventhough there are records in the resultset. Are there any solution for this problem?

Thanks

here is the answer from MSDn:
"Use either adOpenKeyset or adOpenStatic as the CursorType for server side cursors or use a client side cursor. Client side cursors use only adOpenStatic for CursorTypes regardless of which CursorType you select. "

Had the same problem. You must set your recordset's CursorLocation - adUseClient (I dont' remember the exact constant but I think that's what it is). One problem - it has to read the entire recordset into memory to know how many records are there so if you recordset is really big you'll run out of memory.

had the same problem just a few weeks ago. I had two recordsets open (same name). I had forgotten to close one in another form.

David Paulson