Copying Files in VBA

[RedWolf]

I'm writing some code on an access form that will copy some files from one location to another.

I've been using the FSO method to do this copy. It works fairly easily but the problem is I need to find if the copy was successfull.

I'm looping through a large list of database records and grabbing the filenames and copying...

I have code to alert me when it tries to copy files that don't exist (by printing their names to a text file) and this works...

However after running the program and counting the number of files ACTUALLY copied then adding the number of entries in my "not found" file I come up 2 short of the number of files my program should be copying.

This implies to me that it FOUND the two files... but it can't copy them for some reason (I have no idea which 2 and we're talking hundreds). so the command just skips them and moves onto the next one.

SO is there some easy way I can find if the copy was successfull? I'm trying to keep this simple without using API's and stuff...

 

[RedWolf]

EUREKA!

if all I want is to see if the copy was successfull I can simply check to see if the file exists in the new path AFTER performing the copy function.

I can't believe I didn't think of this before.

 

[ainwood]

I would have thought that an error would have been generated if you try to copy a protected / in-use file?

You could always append a file properties - type function to your file-exists function?