Recover a Not a Database File

[codo]

I tried to open some foxpro dbf files and then i found "Not a database file". I know it happens because while im open some dbf file the server turn off imediately and made the files crash. How to restore the dbf file to normal again? Usually i open it with microsoft excel and save it again, but the problem is the index file is become unuseable and sometimes the field with date type become Character type.

 

[TheRambler]

FixDBF can be used to recover your table when you get the error "Not a database file". It can be found at:

http://www.jjtc.com/Fox/foxfiles/

To fix the corrupt index, erase the CDX file and recreate it.

 

[FoxGyver]

For a quick recovery you may use FILEFIX from Norton utilities (Version 6 or 8 DOS Version).

But for a save procedure, backup the dbf often. If the this case occur every time, you may backup the dbf everyday.

 

[rob444]

Or use the CMREPAIR utility on the project file:

http://www.cmstory.com/_cm/CMrepair.zip

Rob.

 

[rob444]

The previous link is/was dead.
Download the 2.6 version here:

http://www.rbftp.com/transfer/foxpro/cmrepair26.zip

Rob.

 

[giridpi]

I think foxfix is good for this problem.I tried its work well.

 

[turbotim42]

If you have the software or know someone who has open the table in VFP pack it etc then save as 2.6, used to have to do this all the time where I used to work stumbled across it accidently one day but found it very useful