>Bill,
>
>>Could this case be tested with a SELECT NOOPTIMIZE ... ?
>
>I'm not sure. Even if VFP is told to not use the index to help it select records it might try to use the index to provide support for an ORDER BY clause. I've usually been so ticked that the CDX has corrupted on a production table that additional testing isn't a high priority.

Gotcha. I was just thinking that a simple SELECT * FROM Mytable NOFILTER NOOPTIMIZE might be a quick way to help narrow down the possibilities of the problem cause. Perhaps not ...