Lori,

If you SET SAFETY OFF the user shouldn't be prompted when you delete the databases or overwrite a file.

You can set RI using the RiInfo field in the DBC. Just open the DBC as a table to see how it's stored. If you have any triggers and/or stored procedures you can save the StoredProcedureSource and StoredProcedureObject code fields from the DBC then restore them using COPY MEMO and APPEND MEMO.

>I wrote a program to reindex the tables if the indicies should be corrupted.I close the databases, open the tables under fopen, delete the indicies and delete the database. I then reopen the tables ,create indicies, and recreate the database. I add the tables to the database and use the use alter table command to make the indicies that I added primary. I also set up a foreign key with the alter table command to set a relation between the two tables. Is there any way to get the program to run without asking the user if he doesn't mind deleting the databases and if he wants to rewrite the indicies that I set up as primary keys at the end. Also, is there a way to programatically set referential integrity?