Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112248 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, November 06, 2006 4:12:22 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



Hi,
First question is there a memo field associated with this table?
And secondly, setting the tablevalidate to 0 is only masking the
problem. You need to resolve the table error under normal table
validate settings.
Pete from the Great White North. (Only in Canada, ay.) Over and Out ...

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