[AccessD] Ensuring FTP completion

Hi John

Didn't you test out 3D-FTP? Piece of cake:

  Const cintLocalDir    As Integer = 0
  Const clngNoError     As Long = 0

  <snip>

  ' Add the database file to the queue.
  Call .AddToQueue(cintLocalDir, cstrFileName, 0, 0)

  <snip>

  intFileCount = .GetQueueItemCount()
  If intFileCount > 0 Then
    lngReturn = .TransferQueue()
    DoCmd.Beep
    If lngReturn = clngNoError Then
      strMsgPrompt = "Transfer of files were successful."
      lngMsgStyle = vbInformation + vbOKOnly
    Else
      strMsgPrompt = "An error occured during transfer of files!"
      lngMsgStyle = vbExclamation + vbOKOnly
    End If
  Else
    strMsgPrompt = "No files to transfer."
    lngMsgStyle = vbExclamation + vbOKOnly
  End If

</snip

If you have to work with the command line FTP or similar you may pipe the screen output to a log file and parse that. No fun.
Or perform the ultimate test: Upload the file and download it right after. Then compare the two files. This, of course, doubles the effective transfer time.

If you are transferring one file only, you can also as Reuben use a small external util, wcl_ftp:

' WCL_FTP is freeware and is obtainable from
'   http://www.pacific.net/~ken/software/

which can be run by an excellent code module which is for download too.

/gustav

>>> jwcolby at ColbyConsulting.com 16-01-2006 21:15 >>>
I am working on a system to FTP an MDB file to a web directory.  I need to
know that the file got there correctly.  Does anyone do this, and if so,
what tools do you use for the FTP up/down and how do you check to ensure
that the transfer completed?  I am going to need to do something like FTP up
under one name, then rename / delete the existing and rename the new to the
filename of the existing.  This has to be bulletproof though so I need to
know that it worked.

John W. Colby
www.ColbyConsulting.com