Overclock.net banner

1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter #1
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?
 

·
Registered
Joined
·
1 Posts
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 https://www.openfiletool.com/dbfopen.html DBF Open File Tool

http://www.ehow.com/how_6208055_open-dbf.html
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
 
1 - 2 of 2 Posts
Top