>I was wrong in my last post. The indexes are structured. Don't know what I was thinking. I have taken the app off line and had the db files restored from before the problem. I put it in place of the problem file and it worked fine. I still need to either fix the current file or figure out what has been changed since the last backup
OK. I still think you should get rid of the index on deleted() (or at least try which is faster - with or without). However, I realize that you have to restore the corrupted indices first.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)