Quote Originally Posted by Patzer
Hi,

you have to set the .cursorlocation property of the recordset to aduseclient.
It is quite clear that .recordcount cannot work without this, as the recordset object "assumes" that the cursor may be server-sided.
You should - additonally - set the .cursortype property to adopenstatic.

Yes, when I set the .cursortype to adOpenStatic or adOpenKeyset, the .RecordCount give me the correct values.

Thanks guys.