Shell command problem 1

[ihaveaproblem]

Form a scheduled NT Task i am calling a access database, which inturn then calles a a batch file using the Shell command to connect to a ftp server and transfer a file.

When I run this from access it workes fine, however when I run the scheduled task it hangs when trying to open the ftp server.

Any ideas why this is happening, and is it possible to send the ftp commands from within Access VBA?

Any suggestions\hime would be wolcomed.

 

[zevw]

Why are using the Shell command.

Run the RunApp from your macro it should work fine!

Let me know.

 

[zmeistr]

zevw,
I have spent the past couple of days trying to launch a simple batch program from Access97 and have been lost in Shell #@!!. Your post has saved me the rest of the weekend to finish my project. Thanks and here's a star ...
-zmeistr...