Two Questions:

1.
I am returning a recordset of information that I want to store in a variant array. The RecordCount property, for the recordset, tells me I have RecordCount of 17. When I go to make the variant array equal to what is being stored in the recordset,the UBound of the variant array is now only showing a count of 13. Is there a specific reason as to why I am loosing information from the transfer??

2.
I have a large recordset of information (RecordCount = 53000); this will be stored in a variant array. I need to be able to loop through the array, and compare a separate specific piece of information (ie. Client ID) with that stored in the array. Would the best way to do this be by performing a Binary Search?? If not does anyone have any other suggestions??

Thanks,
Sam