I have a few projects in Delphi that use Paradox as database and sometimes I have to deal with corrupted tables or headers which is a real pain to solve. Anyway, here are some free tools to help you fixing the tables/headers of corrupted paradox tables or “Key Violation” errors.
This application will check the auto increment primary keys to fix the “Key Violation” errors.
Dr. Regener PdxRepair
This one is not free, but its shareware and can be used 10 times.
It´s a great program, it can repair a table even when Borland Database Desktop or Paradox Data Editor are unable to open it.
Paradox Data Editor
This is a viewer and editor for Paradox tables. It has password protection removing and fix & repair ability. It uses BDE.
Built-in BLOB viewer, filtering and searching, column statistics and structure viewer are tools that covers most needed operations.
Data can exported to many formats e.g. HTML, SYLK, Excel, RTF or CSV and printed.
Its probably the best program I have found to deal with paradox tables. It has a function to repair the table and reconstruct the headers but only works if BDE can open the table.