I need a VBA code working from? inside MS Access (both 2003 and 2007 versions).
This FTP module will receive a name of directory (e.g. C:\LN\BP_2010-03-29\) and it should transfer ALL files from this folder to default directory on FTP server. Host, Login ID and Password will be provided, but you can use any ftp server (requiring authentication) for testing.
The FTP module should be able to capture time of transfer, name of files transferred and responses from the server. All that should be written to Log file in the same folder (e.g. C:\LN\[login to view URL]).
MS Access application will run automatically on Windows 2003 server at scheduled time, so there should be no manual intervention required.
You may develop your own code or use any standard free code (for example, cURL).