Hy Joe,

If the CursorLocation property is set to adUserServer then then RecordCount property is always -1.

You can change the CursorLocation to adUseClient or before create the recordset
to excute an simple sql stament "Select count(*) as NumRecords From ...."

Giuseppe