ProTools contains a unique file repair utility that can be integrated into any FoxPro application.

The following are checked and repaired by FIX_FILE:

• Database file type (dbf, dbf w/memo, etc)
• Position of first record (given data is not shifted)
• Number of fields
• Type of fields
• Length of fields per definition vs. record length in header
• Fields displaced within header
• Extra bytes at end of file
• Number of records in database
• Database file size
• CDX File to be loaded when the file is opened
• Memo files:
  • Next entry pointer
  • Determines proper memo to use (FPT, DBT, PJT, SCT, FRT, MNT, LRT). This makes it simple to repair many of the project/screen/report types of database errors.

Items analyzed and not repaired:

• Potential that data was shifted

Items not analyzed or repaired:

• Missing data within file
• Shifted data within data portion of file
• Extra data inserted into file
• Corrupted data
• Actual Memo and General pointers

When creating empty memo files, Fix_File does not go back and void all memo and general pointers.

Users are given the option to backup data prior to repairs.  Users are given information when repairing a file when a restoration from a backup may be in order.  

The process is very fast. All written in FoxPro! Compatible across Windows/DOS/Mac platforms. SHOULD work from UNIX - but has not been tested it on that platform. 

Source code is included with the ProTools library.