How to have Access copy a .txt file to another folder

B

Bucky

Is it possible to have Access make a copy of a .txt file to another
folder on a network? I have users upload a .txt file to the system,
but after it's uploaded, I want Access to copy the original .txt file
to a "backup" directory so I have a running history of everything
that's been uploaded. Is this possible? How?
 
B

Barry-Jon

The following line of code should do it:

FileCopy strSourceFile, strDestinationFile

Where strSourceFile is a string with the full file name and path of the
file to be copied and strDestinationFile is the full name and path of
the copy file. You can rename it in the copy but you don't have to.
 
Top