Hi Jean Just to reinforce what Dave Crozier has said, we have quite a few customers with 30+ users and tables 1Gb+. Our experience over the last several years has been that the key to stability is the network infratructure. If the hardware/network is good, monthly reindexing is sufficient and data/index corruption NEVER happens. OTOH a faulty network card, old/tired server, environmental interference (eg electrical transients), etc can lead to the sort of intermittent problems you have experienced.
Of course, in that situation the only way to resolve it is change the suspect stuff bit by bit and each time leave it a few days/weeks to see if that has cured the problem - which is not ideal ... Jean Haidar wrote: > We have problems with one of VFP TABLE , it give an intermittent error > message like this > > Index file "\\lrd1fil2\vfpprod\mw\mwdata\profile.cdx" is corrupted. Please > rebuild it. > > we are rebuilding the PROIFLE.DBF often ; sometimes every 2 days by using > these commands: > > for example: > > USE R:\MWDATA\PROFILE in 0 > select profile > copy to c:\data\PROFILE.dbf > USE C:\DATA\PROFILE IN 0 EXCL > > here we rebuild the indexes like this: > > INDEX ON CASE_ID TAG CASE_ID > INDEX ON CUST_ID TAG CUST_ID > etc.. > > PROIFLE has about 29 index tags and profile.dbf is about 1.1 gig in size > > we are able to add and update records most of the time but sometime we are > getting the error message above > from different processes: > > 1) A batch process trying to update the DBF with an update statement like > this: > UPDATE > case_id = &lcCurRecord..case_id > > Error get generated like 7 times between mid November to first December > > 2) A > Error generated like 4 times between mid November to first December > > (lcUpdateTable) ; SET &lcUpdate WHERE ;form Querying the table ( Select > statement include Profile and other table) > Any ideas? > > Thanks, > Jean > [EMAIL PROTECTED] > -- Cheers ============ Brian Abbott ============ _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
