"Not a Database File " Foxpro 2.6 - DOS

[ihabaloul]

I cannt open a foxpro 2.6 tabel (Under DOS) using the use command (USE TABLE_NAME) because of electricty failure , So how could I jump this problem to not lost any data.
IHAB

 

[cricket]

Backup the file with the dbf extention and every other file with the same name but with non dbf extention names.
If it is a small table (<16k records) without memo fields, open it using Excel, and save as a dbf file with a new name . Do not overwrite the original until you have salvaged the maximum.
This will give some data recovery

 

[NasibKalsi]

or

if you have acces to foxplus, then

use damaged_file
use

will fix it as well.

Nasib Kalsi

 

[JRB-Bldr]

Do a Search of this Forum for the numerous previous postings for "Not a Database File". Within those postings you will find a number of suggested approaches towards resolving your problem.

Good Luck,

 

[ezopaci]

You can find some utility to fix this on

http://fox.wikis.com/wc.dll?Wiki~CategoryDataCorruption

Tomas

 

[ihabaloul]

Actually , I have not a foxplus , But I tried few tools such as FIXDBF,FixFoxPO,FIX_DBF all gives a completed and success finish message and I could Opened the Damaged .DBF file but 50% (approximatly) of the data appears in graphical chars. and non-understandable (Dummy) .
Pls. Advice.
Ihab

 

[JRB-Bldr]

Depending on the type of problem encountered there is no guarantee that any of the 'fix' routines with repair 100% of the problems.

Your best possibility would be to get data from the Backup and use is, possibly merged with any newer records.

You might try to use a combination of 'good records' recovered by the 'fix' routines and from the Backup files and from Cricket's suggested Excel recovery method above. When done, merge all of the records, and eliminate the duplicates. Together they might get more of the records.

Unfortunately situations like this just show how important it is to have a good and frequent backup procedure in place. Without it your options are significantly more limited.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[dgrewe]

ihabaloul,
There is a third progam called Dsalvage that repairs damaged DBF's

http://www.hallogram.com/dsalvge/

A little pricy, but it works.