bizarre results

i m using an adodb recordset to display values from an access table but it is giving inconsistent results.instead of going into eof processing if no match is foound it sometimes exits out of vb.(at the same data everytime)i was totally confused so i opened the data file and it does not go to eof.it exits out of access.i fust dont know the problem.is it a virus.is a corrupt datafile creating this problem.pl help.the datafile has 300 records.
thanks in advance.

Would you please show us how you retrieve your data?

Try use the .movefirst method every time you want to verify if it is eof.

I'm afraid that wouldn't be enough - we need to see what you do in details.
That is if you want some answers... ;)

You should try, I got sometimes the same situation with ADODB.Recordset (it's basically the same object) and, since I've started to do that, i've never got "bizarre results". I hope it could result with you.
:cool: