>Ok i have finally isolated the problem - all i need now is to find a solution.
>
>The CDX is actually the index file that is created when auto-complete is used in one of my menus. Hence the double index - the one i use to sort on name and the one vfp creates to fill in the auto-complete. If i delete it, it creates a new one directly i use the autocomplete feature.
>
>Now to the heart of the problem - the error messages we receive are that the cdx is missing - when in fact it is there! We press ignore and the problem goes away - operation is normal. the autocomplete works fine. It does it sparodically. my solution is write a short on error program to ignore error #1707 - but it hardly seems like a dignified solution.

If you have a comprehensive error handler, it can log a lot of information like program call stack, values of variables, open tables/currently selected table etc. You can then examine these log files for clues about what's going on.

If you don't have a comprehensive error handler, you could try Download#29837 (haven't used it myself)