bohdanscekic Posted November 27, 2015 Report Share Posted November 27, 2015 We have a visual basic 6.0 program that updates a FoxPro table through odbc. We have a timer program that starts up every minute to print reports from an action.dbf. Whenever we run a procedure in our program we are opening the tables that we use and then close them. I don't know what happens but sometimes I get an error message whenever we try to open the dbf that the VB program updated. The message is *.dbf has been corrupted. The table will need to be repaired before using again. We have a repair program that we use to fix the dbf file and the repair message says File EOF mark adjusted! (VFP8+). The only thing the VB program is doing is setting a logical field to either true or false. I can't figure out what vb would be doing to cause this problem. Ant help would be appreciated. Thanks! Link to comment Share on other sites More sharing options...
kinsleypatel Posted November 29, 2015 Report Share Posted November 29, 2015 As a variant try next step:Copy a valid memo file over the corrupt memo file to access the database again. NOTE: The original memo field information will be lost unless the valid memo file was an exact backup of the corrupt file. All memo field backup files have an extension of .TBK. The corrupt memo file will have an .FPT extension, such as OLD.FPT. In the following example, assume NEW.FPT is a valid memo file. To bypass the error message and access the database again, type the following command at the MS- DOS command prompt: Copy new.fpt to old.fpt In case the guide is ineffective for your situation, then your .dbf file is severely corrupted and can be restored by more powerful solution for such cases https://onlinefilerepair.com/en/dbf-repair-online.htmlDBF files Online repair service Link to comment Share on other sites More sharing options...
Simping For Hina Posted November 29, 2015 Report Share Posted November 29, 2015 bless u girls for your hard work Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.