I need to automate the following process in Access VBA:
1: connect to an ftp site with username and password
2: download all the files on the site to a folder on the network.
3: verify they were successfully downloaded.
4: delete all files from the ftp site that were downloaded or move them to an archive (just in case).
I need no user interaction on this feature as the database runs on a Windows 2003 server and automatically processes at 2AM in the morning. I have to add this feature to the already existing items that are done.