Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt table
Message
From
20/04/2014 11:05:17
 
 
To
20/04/2014 01:32:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01598836
Message ID:
01598845
Views:
63
>>Hi All:
>>
>>On a USE, I'm getting the following message:
>>
>>
>>Table 'Foo.dbf' has become corrupted.  The table will have to be repaired before using again.
>>
>>
>>When I run a program (SBT) that uses this table, the system crashes with the following message:
>>
>>
>>Table 'Foo.dbf' has a file length/record count inconsistency.  The table will need to be rapaired before transactions can be committed properly.
>>
>>
>>My question is: Is there a way to repair the table without having to restore from a backup? Note that this table is part of a .DBC database.
>
>Does SBT have any sort of repair function built-in?
>
>If you go to the UT home page, click on the "Downloads" link, and search on "Repair" there are several free downloads that may work for you. Before trying any repair utility I'd make a backup of all the SBT data files/DBCs etc. Consider trying repair utilities on a copy of the original data.
>
>More possibilities at http://fox.wikis.com/wc.dll?Wiki~TableCorruptionRepairTools~Wiki .
>
>Before trying any repairs you might want to check the System or Application Event Logs for any disk-related errors, in case a failing disk is to blame.
>
>You can also Google [dbf repair], you'll probably find there are paid and free options. Years ago when I last looked at them some of the "free" ones would repair only the first 50 or so rows of a data file, if your table was larger you had to buy a paid version. Maybe things are different today.

Al,

Thanks for all the info. I'll look into all the options.
Previous
Reply
Map
View

Click here to load this message in the networking platform