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


> > 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


Hi Ilya.

We do a lot of recommendations to our customers, but few of them does something about.

Take a look at my last message to Pete to know what I'm trying to understand...
https://www.foxite.com/archives/0000112655.htm

Anyway, tks for you suggestion!

Emerson Santon Reed
http://weblogs.foxite.com/emersonreed
http://thespoke.net/blogs/emersonreed

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