Gary

Have you looked at the Gendbc u/t. Look it up in help. It ships with VFP and is used to generate code to recreate a database and all its tables, views, etc., along with any RI, etc. If you only want the database container you can excise this from the resulting code and just run this alone.

HTH

Terry

>I have a data replication utility that opens tables and does a "copy to" command to create duplicates. (Yes I am aware I could get orphaned or mismatched data, but this is an "emergency" data copy for a client that can not close systems down).
>
>My problem is that I can not find a way to copy the database (DBC) itself. I can not do a "COPY FILE" on a database that is in use and USE .dbc, COPY TO does not produce a valid database.
>
>Anyone know a way around this?
>
>
>
>Gary Williams.

- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.