>Most of my clients are small business types. Of course I use VFP almost exclusively to design and write their apps. But one thing that keeps bugging me is when will it be my turn to fix a corrupt table and the all the grief that come with it. Fortunately, that day has not come yet, but I feel it will soon.
>
>There is no way that I'll convience one of my "MOM-POP" shops to fork out some bucks to purchase a client server like MS SQLServer or Oracle.
>
>My question is is there a better tables/database that is "more" stable and "reliable" then the VFP native tables?
Database or table corruption doesn't occur frequently. An expensive solution like SQL-Server is not worth the cost - if this is your only concern.
You can reduce table and index corruption with the FLUSH command. Use it after TableUpdate().
Backup, as mentioned in another reply to your question, is of extreme importance, whether you work with VFP, SQL-Server, or simply Excel spreadsheets.
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)
