>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?
In code, you can use the DBC as a table and search for references to the table and delete those records. That's not always easy, however, as you must close the DBC (and any open tables in it) first.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.