Re: Recordcount Returns -1
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. "
Re: Recordcount Returns -1
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.
Re: Recordcount Returns -1
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