The Find methods (FindFirst, FindLast, FindNext, FindPrevious) locate the first, last, next, or previous record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria. A common error that developers make when converting code to work with an ODBC database is to try to replace Seek method calls with Find method calls. As a general rule, this code will be slow.
When trying to find an individual record, the best approach is to create a new Recordset with a WHERE clause that contains the criteria for the records you want to find. This will return all records that match the criteria. Because this is a single operation on the server, this approach is much more efficient than using the Find methods, especially if the number of records returned is small.