FTP with Access 2003

[Guest]

Please help on this issue. After updating a table using a Form, I would like
to perform the following action. (1) Click a button to transfer the latest
update (customer call data) to a remote PC/Server. (2) Upon completion of
transfer automatically download any update issues from the remote PC/Server
to my PC.

Thanks

 

[Guest]

Hi Allen,

Here's one option that I use:
Call a batch file from somewhere in your code

RUN ftp -s:upftp.bat my.website.net

The batch file looks something like this:

Myftpsite%mywebsite.net
ftpdrop1
binary
put whatever.zip
get whatever.zip
bye

Google ftp commands on the web for more options or let me know if I can help.

Bonnie

 

[Guest]

Hi Bonnie,

Thanks for your reply, will give it a shot and check up google for more info.

Regards