Conditions That Cause the Find Methods to Work Slowly

The Find methods are usually slow for dynaset-type Recordset objects on an ODBC data source that have more than 100 records. The algorithm used to resolve the criteria in this case is to retrieve and examine each record until either a match is found or all records have been examined.