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