>Use the File System Object: > >oFSO = CREATEOBJECT("Scripting.FileSystemObject") > >oFSO.CopyFile [source ], [destination ] >oFSO.CopyFolder [source], [destination] > >>>>>>>>>>>>>>>>>>>>> >>I need to copy DBFs / CDXs / FPTs from one directory to another (for backup purposes). The VFP command COPY FILE fails if the table is open. I am currently shelling to DOS and using the COPY command (in DOS) which works even when the table is open, but I would rather not shell out to DOS. Are there any alternatives? I also don't want to resort to ActiveX controls. >>>>>>>>>>>>>>>>>>>>>
I had the same problem and solved it by creating at new table from the structure of the one I wanted to backup. Then appended from the actual table to the backup table.... The backup is done automatically every night.....
It is not the stronges of the species that survive, nor the most intelligent, it is the one that is most adaptable to change. -Charles Darwin