>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?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope