>Can anyone tell me why foxpro creates so many temporary files all over the place and why do the tables have to be reindexed every day or so?
In case you don't already do so: make sure you create indices with the TAG command, not with TO. Thus, VFP will open the index together with the file automatically, and keep it updated.
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)