Use SHFileOperation API for copying files.
___
Private Declare Function SHFileOperation Lib "shell32.dll" Alias "SHFileOperationA" (lpFileOp As SHFILEOPSTRUCT) As Long
Private Type SHFILEOPSTRUCT
hwnd As Long
wFunc As Long
pFrom As String
pTo As String
fFlags As Integer
fAnyOperationsAborted As Long
hNameMappings As Long
lpszProgressTitle As String
End Type
Private Const FO_COPY = &H2
Private Sub CopyFile(ByVal src As String, ByVal dst As String)
Dim fos As SHFILEOPSTRUCT
fos.hwnd = hwnd
fos.pFrom = src
fos.pTo = dst
fos.wFunc = FO_COPY
SHFileOperation fos
End Sub
Private Sub Form_Load()
CopyFile "C:\Data\db1.mdb", "D:\Backup\db2.mdb"
End Sub