Hi Mike,

If you don't mind, I'd like to ask a little more about this. . .

Your runs using FP2.6

1) was it FPW or FPD?

2) Was it on the SAME MACHINE as where you ran VFP?

3) Can I assume that the TAG on DELETED() was in *both* the FP runs and the VFP runs?

4) Around what percentage of the records were actually DELETED() in the tables used for each run?

I will appreciate if you take the time to respond.

Jim N

>If I remove the deleted() tag from the VFP tables, they open instantly.
>
>If I set deleted off, before I open the FPW table, it opens instantly.
>
>Therefore the index on the deleted flag had to be it.
>
>Mike