Problems with old DBF files

[timeslice]

Hi all,

I'm having problems with DBF files. Some of them are not corrupted, but some information inside it are lost, with unreadable data.
My questions are:

1- Why did this files get some information corrupted, and not all the file?
2- How can I recover this data? I tried ADR, with no success.

Any help in this case will be very welcome.

Thanks,

Marcelo Palenzuela

 

[GriffMG]

Hi Timeslice,

The partial corruption is because the clipper application will 'buffer' the changes that are being made before writing them to disk, and if the power fails before the write is finished - your file is spoilt.

The good(ish) news is that the file format (memo fields aside) are generally of a fixed length for each record.

SO, in GENERAL, if you create a new table with the same structure you should be able to do an APPEND FROM to get the good data back - you'll still lose the spoilt stuff.

Regards

Griff
Keep [Smile]ing