Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bob Brook
  Where is Bob Brook?
 Surrey
 United Kingdom
 Bob Brook
 To: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: RE: Table has become corrupted
Thread ID: 112239 Message ID: 112662 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, November 10, 2006 5:09:17 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

Take a look at the Web Blog http://rcl-systems.blogspot.com/
to see an article on VFP 2091 errors and how to fix them using VFP code in a administrators function built into the application.

The cause of the 2091 errors from my limited experience is the conflict that virus checkers cause when writing to the table header record count section. This record is not 'released' by tjhe virus checker and when VFP adds a record to a table the record is added OK but the record count does not get updated.

I always now advise to exclude an applications data folder from an virus checker being run in the background.

Regards

Bob of Surrey, England

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