Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112489 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, November 09, 2006 1:00:12 AM         
   


> I'm trying to open a table in VFP (in the command window) and receiving an error:
> 2091 - Table has become corrupted. The table will need to be repaired before using again.
> If I issue a set TableValidate To 0 command and try to open the table again, I receive a message "Memo file repaired. Proceeding" and the table is opened correctly.
>
> If I do the same in my application at run time, after issue a set TableValidate To 0 command, and try to open again, I receive an error:
> 41 - Memo file is missing or is invalid.
>
> Why not working at run time?
>
> Emerson Santon Reed
> http://weblogs.foxite.com/emersonreed
> http://thespoke.net/blogs/emersonreed


Emerson,

After you've read and done all that Pete and Budewijn advised, it's time to get back to the cause of the DBF/FPT files corruption.

This same problem used to be the permanent headache when it was all on our in-house file servers. Nothing helped, even UPS with 10-minutes run-out time. Once we moved the data to a "server farm", with their own superstable in-house power plant - no headaches of this nature anymore!

So, the main cause of such corruption is faulty hardware, or unstable voltage, or both.
Just to give you some food for thought... and HTH.

Regards,

Ilya

ENTIRE THREAD

Table has become corrupted Posted by Emerson Reed @ 11/6/2006 2:58:37 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/6/2006 4:12:22 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/6/2006 5:07:20 PM
RE: Table has become corrupted Posted by Pete Sass @ 11/7/2006 5:41:44 PM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 8:30:02 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/7/2006 11:12:05 AM
RE: Table has become corrupted Posted by Boudewijn Lutgerink @ 11/7/2006 11:51:15 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/8/2006 11:43:02 AM
RE: Table has become corrupted Posted by Pete Sass @ 11/8/2006 9:15:19 PM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:18:06 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/9/2006 1:00:12 AM
RE: Table has become corrupted Posted by Emerson Reed @ 11/10/2006 1:26:14 PM
RE: Table has become corrupted Posted by Ilya Rabyy @ 11/10/2006 4:49:31 PM
RE: Table has become corrupted Posted by Bob Brook @ 11/10/2006 5:09:17 PM