>We have a VFP database consisting of about 400 free tables and 330 tables included in a database. We suspect a corruption somewhere (database, index, table) because we're having very strange behaviour from our application (see thread 1662003), but we cannot find what item is corrupt. Is it the database, an index (which one?), a table (which one?).
>
>I've done a VALIDATE DATABASE RECOVER, I've deleted and recreated some tables, but we still having problems.
>
>I'm now thinking of rebuilding the database and each table from scratch and import the data afterward, but with over 700 tables to recreate (without counting the indexes), it would be a enourmous task. I can create a program that will scan each DBF, get the table informations with AFIELDS and ATAGINFO and write everything in a text file that I will after manually adjust to make it a PRG that will recreate the database, but it will still require a lot of work and there some chances that it miss some items and create data corruption.
>
>How would you abord this problem and what would be your solution?
>
>TIA

Check GenDBC in Help.