Hi John,

>So it seems to open all the files correctly.

I would have assumed that at some point VFP tries to write a temporary file holding the query result. For example, VFP can hold a cursor entirely in memory, but if you try to index it, it gets written to disk. This leads to the effect that a program works just fine, even if the temporary directory is misconfigured, but suddenly fails on the INDEX ON line. I could imagine something similar happen with memo fields.

Christof