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: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112251 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, November 06, 2006 5:07:20 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 ...


Yes, the table has a memo field.

Pete, I'll try to simplify the question: ;)

In VFP command window:

--- In my machine with VFP 9 SP 1, Win XP SP 2 ---
Set TableValidate to 0
Use [MyTable] Exclusive
* Error 41, occurs and don't open the table

--- In another machine with VFP 9 SP 1, Win XP SP 2 ---
Set TableValidate to 0
Use [MyTable] Exclusive
* Shows "Memo file repaired. Proceeding" and table is opened normally

At run time:

--- In both machines ---
Set TableValidate to 0
Use [MyTable] Exclusive
* Error 41, occurs and don't open the table

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