Hi all,

Ok my scenario is this. My company has a network drive which contains some important Access 2.0 database file (mdb) for daily use. My department has to backup all of them everyday. Due to that they're in different directory, I have written a program to just copy them to the backup folder.

I use the FileCopy function to copy but there is one problem. Some of the staff might still be using the file while I'm backing up and cos of this, FileCopy doesn't allows me to copy this anymore and I will have to turn to Window Explorer to copy this specify files which are not copied over by the program (it works in Explorer somehow)

So is there any VB functions or codings that allows me to still able to backup my files just like the Window Explorer copying?

Thanks for any help!!