DB transfer to FTP at ISP

[Amateur]

Dear Sirs,
I have two databases whereby one of them has always (after updating) has to
be transferred to my ftp at my ISP.
This I would like to do with a command button.
In detail:
Database 1 has a command button which sends Database 2 to my ISP. The
database which has to be transferred is called “transferdb.mdbâ€. It has to be
transferred from: C:\Documents and Settings\xxxxxxxxx\Desktop\cps207\ . It
has to be transferred to: ftp://ftp2.xxxxxxxx.es/Data/
Can someone tell me the correct command code?
With kindest regards
Klaus Müller

 

[Steve Schapel]

Klaus,

A couple of resources for you to check out...

http://www.mvps.org/access/modules/mdl0015.htm

http://www.chilkatsoft.com/ftp-activex.asp

I have made extensive use myself of the Chilkat component, and find it
excellent.