UPLOADING DOCUMENTS

[Developerme]

OK, I have Access 2007 database running on 2008 server Web access or Remote
desktop subject to users choice. Software I run on it needs to ability to
"upload" documents. In essence, I think this is more of a copy and past
function from the client computer to the server. The process needs to be
transparent to the user as much as possible. I know they can copy document
from client drive to server drive, but I want to find out if there is a code
where they click a command and make this process automatically run. Does
anyone have any ideas?

 

[Arvin Meyer MVP]

I'm not sure if Access 2007 still supports FileCopy, but it should for
backwards compatibility. Here's an entry from an earlier version Help file:

This example uses the FileCopy statement to copy one file to another. For
purposes of this example, assume that SRCFILE is a file containing some
data.

Dim SourceFile, DestinationFile
SourceFile = "SRCFILE" ' Define source file name.
DestinationFile = "DESTFILE" ' Define target file name.
FileCopy SourceFile, DestinationFile