SFTP in MsAccess

I have an MSAccess Database (2010) application that collects specific files and maintains a file reference in the database. I now need to upload added files to a website via SFTP (SFTP is not FTP on SSL and is not FTPS) Specific restrictions on solution: A) Coding MUST be in MSAccess VBA (NOT VB6 or something else) B) Functions can call third party software as long as the third party software is freeware or open source. No licence restriction on use is permtted. eg use of [login to view URL] is allowable provided the requirement of B is also met. C) If third party software or DLLs are utilised they must not require installation / [login to view URL] or such on other machines when distributing the application. It must simply work OR a VBA function that checks for and correctly registers the component automatically would be an essential deliverable. D) a solution that writes an SFTP script and passes to another application is NOT acceptable as the database cannot monitor progress E) solution must handle any key exchanges without requiring user intervention. (or provide options to choose behaviour) So what I specifically want is someone to code MSaccess VBA functions that my application can call to perform the following 1) Establish an SFTP session (Parameters: Hostname, Account, Password, Optional port number) must allow for specification of proxy when needed 2) Execute Basic SFTP commands : getafile, putafile, makeDirectory as a minimum the get and put file will have two required parameters: full path and file name (local) full path and file name (Server) 3) Getfile and putfile commands must have a timeout so the call returns failed rather than hanging or provide events/mechanisms for triggering specific functions on completion / failure Mutli threading and events is not necessary, sequential operation of functions is acceptable (ie is is acceptable for the get and put functions to only return upon completion or failure) however the developer is given freedom on this aspect provided the overall goal is acheived Return codes should include indicators of : Timeout, File not found, no permission to write 4) Both get and put will need to automatically create the destination directory if it does not exist OR the programmer will need to provide a function to test if a destination directory exists on the SFTP server 5) Close session function 6) A specific example function (that is testable) calling each of the functions in turn to establish a session place a file place another file get a different test file test for a non existant directory (if get and put do not support auto directory creation) make a directory place a different file in the new directory working example must (obviously) provide all necessary structures needed eg if the function assumes the parameters are passed in a structure then the example must show the esablishment and use of that structure. Eg Global Variable for session handles etc Allowable assumptions: I) All steps may be sequential, support for multiple simultaneous requests is not necessary II) Only one session may be established at a time.