>I need to make a copy of a database (DBC/DBT/DCX) to another directory at runtime.
>
>1) The DBC is OPEN, yet I can copy it fine with Windows Explorer and the copy can be OPEN DATABASE.
>
>2) VFP doesn't allow doing a COPY FILE for all three files because the database is OPEN (in use).
>
>3) I tried USEing AGAIN the DBC as a table and then COPY TO, but the copy is not recognized as a database and cannot be opened. All deleted records are gone from DBC copy but all remaining records are identical. hmmm
>
>4) I then USED AGAIn the DBC as a table, SET DELETED OFF, COPYed TO, (which preserved the records, although not deleted) then deleted appropiate records in copy, but copy is still not recognized as a database grrr
>
>5) I even trid doing a SQL SELECT with deleted off and then deleting the appropiate record, but again no.
>
>What is needed may be to make a Windows copy via some shell, but I don't now how to do this.

I think so too, e.g. use the Win API directly:

DECLARE integer CopyFile IN WIN32API string, string
? CopyFile( oFile.Name, ADDBS(m.lcFolderDestination)+oFile.Name )

(But still any attempt to copy files which cannot be opened exclusively can lead to inconsistencies every here and then.)



hth
-Stefan