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: 112661 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, November 10, 2006 4:49:31 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


Oh, so it's not in-house problem but at customers' sites? I didn't realize that, sorry.
That also did give us troubles. The easiest way is to have a backup - or "mirror", if you will - of customer's data in-house, and when corruption happens at the customer's site - just send them replacement from that mirror data. That is - if it's at all possible.

As to why repair succeeds on one machine but not on another, seemingly identical machine - I would not know. (Apparently, those machines are not that identical as they seem.) The same with why memo repairing succeeds on your machine when running VFP's IDE but does not when you run your EXE on that same your machine: I don't know (although I also have seen similar behavior).

What your program does, if I may ask? If it only reads archived data - you may want to try to open the tables in Read-Only mode, i.e.
USE MyTable.DBF IN 0 NOUPDATE

However, if your program is used for data entry, or for storing data and updating tables - that may be a tough task to prevent corruption... What's stored in that Memo field? Images, ASCII text, MS Word DOCs, PDFs?

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