If (Time()=[11:04:00]) dirtarget=Alltrim("Z:\Backup\")+Alltrim(Dtos(Date())) If Not Directory(dirtarget) Md (dirtarget) Endif dirsource='D:\ATSQL_17\TABLES' Thisform.copyfolder(dirsource,dirtarget) Endifand copyfolder function has these codes
<vfp> **FUNCTION CopyFolder as Boolean LPARAMETERS vSrcDir as String, vTgtDir as String LOCAL oFSO as Object, llOverwrite as Boolean, llReturn as Boolean llReturn = .F. * // Check source directory IF DIRECTORY(m.vSrcDir) * // check target drive IF DIRECTORY(JUSTDRIVE(m.vTgtDir)) m.vSrcDir = JUSTPATH(ADDBS(m.vSrcDir)) m.vTgtDir = JUSTPATH(ADDBS(m.vTgtDir)) llOverWrite = .T. oFSO = CREATEOBJECT([Scripting.FileSystemObject]) oFSO.CopyFolder(m.vSrcDir, m.vTgtDir, llOverwrite) ENDIF ENDIF oFSO = [] RELEASE oFSO IF DIRECTORY(m.vTgtDir) llReturn = .T. ENDIF RETURN llReturn **ENDFUNCSQLSERVER Management studio is closed but users are working on client pcs'.