How to recover the Visual Foxpro 5.0 .dbf and .dbc files?

[VCat88]

I have problem with database corrupted. So how to repair a table .dbf files and how to recover a .dbc files. (Without restore data) ???

 

[VCat88]

Internal Consistency Error.

Cannot resolved backlink.

Any Idea on solving this problem?

 

[Mike Gagnon]

VCat88

There are tools on the internet to repair tables.
Here are some links:

http://www.experts-exchange.com/Databases/FoxPro/Q_10168019.html

http://www.hallogram.com/datatool/

http://www.hallogram.com/foxfix/

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first

 

[ramani]

HI vcat88,


"I have problem with database corrupted. So how to repair a table .dbf files and how to recover a .dbc files."

"Internal Consistency Error."

"Cannot resolved backlink."

Any Idea on solving this problem?



The errors could point to DBC/Tables or project.

1. Before attempting anything,
Open the project
With the project selected, click on the project Tab
in VFP menu
Click on Clean up project.

Often the problem could get resolved.

2. If this error is because of a table, which was belonging to a DBC, but forced open using some other way.. or .. you have shifted the relative position of tables, by physically copying the table of one DBC to another DBC... The back link etc issues propup. You can remove that table and then create it in a proper way.

In the FAQ area I have posted a thread with utility to copy tables from One DBC to Another DBC.

Utility to copy DBFs from one DBC to another DBC
faq184-629

Hope this helps you
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com