Hi Maria.

>I am running into an annoying little quirk. I am checking for the existence of specific database .dbf files in my program, if they don't exist I am using Create Table to recreate the .dbf file in the database. But if the .dbf file was deleted and not removed from the database , say accidentally by a user external from FoxPro, the database still references the .dbf file which no longer exists. I can't use Validate Database Recover in code, it can only be issued from a command window.

You can use Stonefield Database Toolkit (SDT) to handle this for you. If you call its Update method, it will detect that the table doesn't exist and automatically recreate it. This method also automatically updates the structure of a table (for example, when you ship a new version of an application to a client and you've added new fields to a table).

SDT does other things, too, like repair corrupted table and memo headers and recreate corrupted indexes.

For more information on SDT (including a demo version), check out Stonefield's Web site.

Doug