FoxPro .dbf file

[ashtonward]

Good afternoon!

The situation is this. I have never worked in FoxPro but had to face. Generally, an error "Not a database file."

 

I checked in a folder and there are KH.dbf, and KH.cbf. Check downloaded viewer without opening the database with the same error. The most interesting is that on Friday afternoon, everything worked, and this morning is here.

May be someone knows how to open dbf file?

[Boris]

Are you really using 20 year old database software ?

 

Or is it Visual FoxPro ?

 

.DBF files can be opened by Microsoft Excel and Microsoft Access (earlier versions [Office 97 definitely] probably Office 2000 as well ?)

[samuelpearce]

First I would suggest you to use next helpful topics dedicated to DBF files, in case guide below or these topics can't assist you, then make use of more powerful solution for severely damaged dbf files 

http://www.idganswers.com/question/14773/how-to-fix-dbf-file-error-missing-the-support-library

http://itknowledgeexchange.techtarget.com/itanswers/corrupt-dbf-files/

 

if you have access to Visual FoxPro command line window, type:

SET TABLEVALIDATE 11

USE "YourTable" EXCLUSIVE    && If the table is damaged VFP must display an error here

PACK    && To reindex the table and deleted "marked" records

PACK MEMO    && If you have memo fields

After doing that, the structure of the table must ve valid, if you want to see fields with invalid data, you can try:

SELECT * FROM YourTable WHERE EMPTY(YourField)   && All records with YourField empty

SELECT * FROM YourTable WHERE LEN(YourMemoField) > 200   && All records with a long memo field, there can be corrupted data

[Boris]

OP hasn't returned after posting the question 10 days ago !