SET SNIP ON
>- if a DBC or DBF file is missing, recreate the database;
>- if a DCX or CDX file is missing, reindex the DBF and the DBC;
>- if a DCT or FPT file is missing, recreate the database.
>
>I think I'm not 100% right about this. I can do that way but recreating the database would result in data loss.
>
SET SNIP OFF

Alonzo,

From the top down:

1) DBC/DBF missing -- if you also create or utilize some type of active data dictionary, you could create these "on the fly" if they were missing, but there would be no data in anything that was created.

2) DCX/CDX missing -- check out Stonefield Database Toolkit's repair and reindexing capabilities.

3) DCT/FPT missing -- same as #2.

HTH.