[AccessD] A2K: Determine what needs to be copied fromFTP Location

I second the 3DFTP recommendation.  I am programming to the API as we speak.



John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, March 16, 2007 6:12 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2K: Determine what needs to be copied fromFTP
Location

Hi Darren

I guess your requirements leave out a simple shelling to ftp.exe -s?

If so I can strongly recommend to use 3D-FTP:

     http://www.3dftp.com/api.htm 

It is buyware at a ridiculous low cost of USD 40, and it has a very well
documented API.

You can run it with a minimum of code:

    Set FTP = CreateObject("ftp.API")
    With FTP
      .Connect("ftp.3dftp.com")
      .ChDir(REMOTE_DIR, "/pub/")
      .ChDir(LOCAL_DIR, "c:\temp")
      .AddToQueue(REMOTE_DIR, "*.*")
      .TransferQueue()
      .Disconnect()
    End With
    Set FTP = Nothing

but you have, of course, many more options.

Best of all, it runs rock steady (I've never seen it fail) and at an extreme
speed because it is multithreaded. I used it recently for an app which
frequently has to upload about 2000 files by the push of a button.
Here it was a pleasure to have a window showing the progress and success of
the upload.

/gustav