I am using FileCopy to copy a PDF file from my local hard drive to a network share.
The FileCopy part works fine but when I go to delete the folder that the source file is stored, it tells me that the file or folder is in use by another program.
One thing that allows me to delete the folder is if I close down Access. It is like Access "releases" the folder so that it can then be deleted. I'd like to be able to delete the source folder if I want to without having to close Access every time.
Any thoughts on this??
The FileCopy part works fine but when I go to delete the folder that the source file is stored, it tells me that the file or folder is in use by another program.
One thing that allows me to delete the folder is if I close down Access. It is like Access "releases" the folder so that it can then be deleted. I'd like to be able to delete the source folder if I want to without having to close Access every time.
Any thoughts on this??