>VFP is indeed a fast database engine, that is why i love to use it, however, its index really causes my headache, it corrupts so often.
>What are the causes of index/table corruption and is there anyway to prevent it (may be just i wrote some codes wrong, i am using VFP6SP3). This is I really want to find out. I look forward to your expert advice.
Check out
http://fox.wikis.com/wc.dll?Wiki~CDXCorruptionChecklist~VFPAlso if your network is Novell, make sure you're using the latest client software on the workstations (if using Novell Client32 rather than the Microsoft Client for Novell Networks) and that its caching settings are turned off.
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~?2,15,423553
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up