performance problem with FileCopy on usb key

[Alain Bourgeois]

Dear all,

I have a vba instruction to copy a closed file (80Mb avi) to a USB Key.
-> Call FileCopy ("c:\mydir\movie1.avi", "J:\video\movie1.avi")

Antivirus is turned off, J: is a USB stick.
Strange problem:
1. Copy is done right but 333Kb/seconds (Ouch!! Takes 4 minutes to copy the
file.)
2. Copying same file via explorer copy/paste or via total commander to same
destination (j:\) occurs at 6.6 Mb/s. (~12.5 seconds)
3. If I disconnect the usb stick and connect a USB external HD at the same
place, copy to HD using same vba FileCopy instruction occurs at 15Mb/s.
(~5.5 seconds).

It seems copy to USB stick via FileCopy is bugged, as
* the problem is not in USB speed as copying to external HDD through the
same USB occurs at 15Mb/s,
* the problem is not in USB stick speed as copying via windows explorer
occurs at 6.6 Mb/second,
* problem is not in antivirus as it is turned off (and if it was antivirus,
it would also occur using external HD).

Problem reproducable at will with access 2003 on win xp sp3.

Any hint / workaround?

Regards,
Alain

 

[Clifford Bass]

Hi Alain,

Try a DOS copy instead:

Shell "cmd.exe /c copy ""c:\mydir\movie1.avi"" ""J:\video\movie1.avi"""

Clifford Bass