The indexes are not breaking because of anything VFP is doing (or not doing). There are VFP solutions than run for years without index repairs.

When you index - make sure to delete the tags and INDEX (not REINDEX). There was a thread on this a few days back.

It might be good to hire a contractor to check and tune your network. At the very least, have your wiring checked. Try to determine why it is failing - VFP can be forgiving to a point - but you've got some connectivity issues making your app look bad (know what I mean) - so get it fixed before it becomes an embarassment :-)

It would be a shame to spend all sorts of bucks and still have the same problem. Whats with the gigabyte file (shouldn't some of it be archived?).


>Thanks Sylvain
>
>The UPS is already in place, and so is the indexing happening after workhours but still i get this error.
>
>As for changing backend..i am trying to get it approved by the heads.
>
>What am i missing here ??
>Dinesh