>>Depends on your design, the amount of data and the stability of your system.....! The total size of our tables including FPT and CDX is about 4GB, and I have had only one (o-n-e) crash is 20 years which forced me to pack and reindex. And this is a 24/7/365 system, and only DBF tables.
>
>We're not that lucky. We keep getting Invalid Seek Offset problem with the older version of the program, which is currently in production. Since I don't know, what change that I made eliminated the problem, we may have to repeat shooting in the dark. In the meantime we have to repair database every time it happens...

Yes, I followed that thread for a few weeks <vbg>. I always suspected an invalid index expression, meaning an index expression which resulted in a varying length key, but I never "dared" to jump in. Have you ruled out that possibility?