Scott,

I have another question. We have a folder where we have the most recent version of the database (let me call this the Central Folder). Every night these tables are copied to the Production and Test folders. And then the tables in the production and test folders are zapped and later updated with the most recent data.

So the tables in the Central folder acts like a template and it really has no data. This was done so that any changes that are made to the tables wouls have to copied only to the central folder. What our application does now is that:-

- it determines if every file in the Central folder is also in the Production and Test folders and if not copies them over using 'Copy File' command.

But when we do it this way, if a table has had structural changes, the table would not be copied to the Production and Test folders as it is already there.

What I am thinking about doing is, that, I could copy all the files in the Central folder to the Production/Test folders irrespective of, whether they are already in these folders.

- Can I use the 'Copy File' to copy these files?
- Will this corrupt the tables? or cause index files mismatches?

Thanks for all the help.

Ria