Link to home
Start Free TrialLog in
Avatar of APD Toronto
APD TorontoFlag for Canada

asked on

Err 3167- Record is deleted @ MeveNext

Hello Experts,

I have the following structure, which I use routinely:

Do While Not rs.EOF

   'other code

   RS.MoveNext
Loop

i've been reciving lately Err 3167- Record is deleted. on my rs.MoveNext.  What could this be? Can my db be corrupt?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"RS.MoveNext should not result in such an error message."
I don't think that can be guaranteed ...

mx
Avatar of APD Toronto

ASKER

I copied the table into a new one and that did it.

thanks all