Don't let the database and the tables get too big. I always tell my clients that after about two years, to archive the data and start anew.
But I haven't run into a lot of data problems.
It's also good to give the client a tool to recreate the indexes if needed.
>Greetings All,
>
>Just how stable is data integrity in VFP? How often (in a stable environment) do index corruption occur? Reason for asking is I've inherited an Access program which I made the suggestion that VFP would be better to use (i.e. multiuser, speed, etc. - list is too long :) ) however I'd like to know if there are any "major" issues with corruption and if I would be better off utilizing a 3 party product to deal with things.
>
>Any opinion is highly appreciated.
>
>Thank in advance,
>
>Vernon
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching