>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. What can I do in code to remove the database reference to the deleted .dbf file before recreating it?
>
>Thanks in advance!

Couldn't you just pack the database, there by ensuring that no deleted records are in it?