-
ADO Find Problem
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
-
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!