File in use exception - How do you copy a file and not have this exception?

[emaduddeen]

Hi Everyone,

I'm using FileIO.FileSystem.CopyFile to copy an Access database but get a "File in use" exception.

How do you make a file not in use and after copying the file make it back in use?

Thanks.

Truly,
Emad

 

[jmcilhinney]

If you want a file to not be in use then you have to not be using it. If your app is the one using then it must close whatever connection it has open on the file. If your app is not the one using it then you're out of luck.