I have an application that I wish to allow users to create a duplicate of the databases and tables. For example a multi office application where the underlying information is completely different but the dbc/tables/application are exactly the same. I have coded to allow the users to select between datasets by creating separate subdirectories and datasets beneath the application main directory. Now I want to programatically copy the database & related tables to a subdirectory if a user wants to add a new office to their application.

In order to maintain system integrity I want to have a unique name for each new database so I copy the database and related tables then rename it. I can easily validate the new database with "recover" through the command prompt then manually reply 'yes' to resolve the back link messages but I would like to automate this process so it is invisible to the users.

Does anyone know of a way that I can accomplish this? I have tried using the ON ERROR to return a "YES" (6) then calling Validate Recover, but the validate routine seems to ignore this. I assume it's not actually generating an error but a message.

Thanks,
Greg Taylor