VB and Batch file from Access

[JT]

I'm trying to run a program from Access that will run a batch file to
download a file using FTP. I'm having a little difficulty because the batch
file completes before I'm connected to the site where the download will come
from. Any suggestions? Thanks.

 

[Tim]

By default, the Shell command runs asynchronously (and so make not be
finished before your code continues). Take a look at this link for how to run
the Shell command synchronously:

http://www.tek-tips.com/viewthread.cfm?qid=1135370

HTH

 

[David C. Holley]

There might be a ActiveX Control out there handles doing FTP's. I
personally don't have expereince doing automated FTPs from within VBA so
can't help you further.

 

[Brendan Reynolds]

There's code to call FTP from VBA at the following URL ...
http://www.mvps.org/access/modules/mdl0015.htm