none
Error 2091- Table corrupted.

    Question

  • When opening a table that exists in a project I got the following message-
    Repair the table using an appropriate third-party repair utility for Visual FoxPro tables before opening the table again.

    What does this mean & how do I find a third-party repair utility? 

    Thanks!!!
    Monday, July 25, 2005 3:43 PM

Answers

  •  Alex Feldstein wrote:

    SharathMum wrote:
    SET TABLEVALIDATE TO 0 (zero)

    this will solve the problem

    for detail refer VFP9 help

    SET TABLE VALIDATE TO 0 does not "solve" the problem. All it does is mask it. VFP 9.0 is does stricter checkings and finds things that were wrong but not caught by the parser before.

    Even though it gets you going for the moment, it does not fix the problem, just hides it. You should still see what's wrong and fix it in the table itself.



    i agree with u,
    its my mistake i should have post the warning also that its a temporary solution

    Tool to Repair
    CM Table Repair Utility  http://www.universalthread.com/wconnect/wc.dll?2,54,1,5





    Thursday, September 28, 2006 2:13 PM

All replies

  • I found the software I needed.  If anyone else out there needs this info let me know by replying to this post.  Big Smile
    Monday, July 25, 2005 6:57 PM
  • SET TABLEVALIDATE TO  0   (zero)

    this will solve the problem

    for detail refer VFP9 help

    Thursday, September 28, 2006 12:52 PM
  •  SharathMum wrote:
    SET TABLEVALIDATE TO  0   (zero)

    this will solve the problem

    for detail refer VFP9 help

    SET TABLE VALIDATE TO 0 does not "solve" the problem. All it does is mask it. VFP 9.0 is does stricter checkings and finds things that were wrong but not caught by the parser before.

    Even though it gets you going for the moment, it does not fix the problem, just hides it. You should still see what's wrong and fix it in the table itself.

     

     

    Thursday, September 28, 2006 1:43 PM
  •  Alex Feldstein wrote:

    SharathMum wrote:
    SET TABLEVALIDATE TO 0 (zero)

    this will solve the problem

    for detail refer VFP9 help

    SET TABLE VALIDATE TO 0 does not "solve" the problem. All it does is mask it. VFP 9.0 is does stricter checkings and finds things that were wrong but not caught by the parser before.

    Even though it gets you going for the moment, it does not fix the problem, just hides it. You should still see what's wrong and fix it in the table itself.



    i agree with u,
    its my mistake i should have post the warning also that its a temporary solution

    Tool to Repair
    CM Table Repair Utility  http://www.universalthread.com/wconnect/wc.dll?2,54,1,5





    Thursday, September 28, 2006 2:13 PM
  • Hi,
    Check this if it could help.

    http://ckkiet.blogspot.com/2004/07/one-of-possible-cause-vfp-table.html
    Monday, December 11, 2006 10:53 AM
  • I am having the same issue with this error after converting from version 7 FoxPRo to Version 9

    Were you able to find a 3rd party fix?

    Thanks for your help,

    Don

    Thursday, May 15, 2008 10:21 PM
  • I have run across the same issue and would like to know if you stil have ny information regaardint he 3rd part software for that will correct the issue.

    Thanks for your time,

    Don

    You can email me at dkaiser@maurymw.com

    Monday, May 19, 2008 3:33 PM
  • e

    Wednesday, January 21, 2009 12:04 AM
  • try this one only need 4 steps

    SET DEFAULT TO X:\DATABASE --> db folder

    SET TABLEVALIDATE TO 0

    USE TABLECORRUPTED  --> table corrupt that you want to repair

    PACK

    Cheers,

    St - http://www.ehkelectronics.com

    Thursday, May 3, 2012 7:17 AM
  • For anyone with the same problem - corrupt table - this article shows you what can go wrong with a VF table and how to fix it.

    http://rcl-systems.blogspot.co.uk/2006/09/visual-foxpro-corrupt-tables-due-to_26.html

    It surprises me that MS did not bother to provide a "corrective procedure" when deciding to invalidate a table! Too late now though.

    Thursday, May 3, 2012 8:48 AM
    Moderator
  • A tool to repair a visual foxpro database is FoxFix

    http://www.xitech-europe.co.uk/foxfix.php

    It is also possible to make a small program to check all visual foxpro database, list the corrupted tables, and after that repair them.

    Robert van der Sanden

    • Proposed as answer by yanyee Thursday, May 3, 2012 2:37 PM
    Thursday, May 3, 2012 2:33 PM