Vba code which can execute FTP script from within the Access 97 module 
Author Message
 Vba code which can execute FTP script from within the Access 97 module

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.??



Thu, 24 Mar 2005 00:37:53 GMT  
 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.??



Thu, 24 Mar 2005 01:14:13 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. One workstation cannot open or execute VBA code in Access 97

2. Creating Modules in Access 97 using vba code

3. Executing Excel-VBA code within a Access-database

4. Creating new Access 97 database by VB code in Access 2000 module

5. Class modules 97 - Refering to array within a custom class module

6. Converting VB code modules in Access 95 to Access 97

7. vba code to copy table from access 97 to excel 97

8. outlook forms script editor - execute VBA editor modules

9. Execute Access 97 Report from VBA

10. VB Script Problem in access 97 / Module

11. Problems with MS Access 97 and VBA modules

12. Executing MS Access modules from within VB

 

 
Powered by phpBB® Forum Software