>For what its worth, I have 4 VFP applications running 24/7 on a large corporate network for last 6 years. I have never had an index blow.
I am curious, how do you update the database structure in this case. Do you bring the system "down" for half an hour or so, or did you find a way to avoid this?
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)