
Vba code which can execute FTP script from within the Access 97 module
A simple way to FTP is shown at
http://www.mvps.org/access/modules/mdl0015.htm at "The Access Web".
A more sophisticated approach is to use the Internet Data Transfer Library
at http://www.mvps.org/access/modules/mdl0037.htm
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
Simply I have an access 97 database that creates a couple of tables
I need to transfer these tables into an AS400 hub - To do this I can use an
FTP Application such as Reflection - This works fine.
But i want to automate the process with Access - Is there anyway that i can
get Nt4 to think to relinquish control to Access.
ie I can go into Start Command and type FTP to launch Sys32FTP exe and typr
the commands - But can I get Access to do this through vba code?
I have tried call shell.... But that just launches FTP exe - I still have to
typr in the script!
I can even call shell for Reflection - This launches the apllication - and
then run Ftp sript file from there - But can I somehow use Rflection engine
or FTP exe engine through VBA module to execute an FTP script file - Surly
this has been done by somebody long ago.??