ADO Find Problem

[BillM]

I am getting inconsistent results with a Find method. I'm using VB6, ADO and Access 97. Sometimes the Find method finds the record, sometimes it doesn't. It appears to only be happening on one particular database. I have repaired, compacted, etc. this database, but nothing works. Any ideas? Is this database corrupt even though it doesn't appear to be? Is the Find method reliable 100% of the time? Is there a way to code around this problem? Thanks!

- Bill

[PeterCr]

Hi There

Maybe I can help you in the right direction.

For solving the problem:
I've seen lots of troubles with joins on an Access-table when using ODBC. What version is your ODBC-driver?

Are you using an index (and is it the right one?)

Some possible workarounds:
- use SELECT-statements in the source of the recordset to find specific record(s)

- use the Filter-option of the recordset to find the record

Success!