How do I FTP over SSL (explicit encryption) via MS Access?

[lunchroom]

I can currently submit files via Windows' built-in FTP.exe over an
unsecure connection with no troubles. However, I now need the ability
to submit files to a secure server using FTP over SSL using explicit
encryption. I currently do the transfers manually once-per-day via
FileZilla GUI, but I want to be able to do it programmatically within
MS Access.

Any suggestions? I've found some command-line utilities out there for
PERL or JAVA - I'm looking for something that someone has already made
work with MS Access.

Thanks.
lunchroom

 

[James A. Fortune]

I can currently submit files via Windows' built-in FTP.exe over an
unsecure connection with no troubles. However, I now need the ability
to submit files to a secure server using FTP over SSL using explicit
encryption. I currently do the transfers manually once-per-day via
FileZilla GUI, but I want to be able to do it programmatically within
MS Access.

Any suggestions? I've found some command-line utilities out there for
PERL or JAVA - I'm looking for something that someone has already made
work with MS Access.

Thanks.
lunchroom

Try the WinSCP beta. It advertises SSL support. I haven't used it in
conjunction with Access so post back if you have success using it from
Access.

http://winscp.net/eng/index.php
http://winscp.net/eng/download.php

James A. Fortune
(e-mail address removed)

 

[Steve Schapel]

Lunchroom,

I recommend the FTP control from Chilkat www.chilkatsoft.com/ChilkatFTP.asp