I'm using WinSCP in the scripting mode with an MS Access 2K application.
My goal is to use the shell command that runs a batch file that ftp's a file.
THe MS Access application needs to know when the FTP has completed, so I use a batch file to copy a flag into the directory.
The Access Application then loops, checking every second to see with the flag exists, before it continues...
The problem is that while the batch file works as expected when executed from the command mode, it does not perform as expected when I use the Shell command.
I'm pretty sure the problem is the use of the term "exit" in the WinSCP script, but I don't know what to do to solve the problem.
Here is my batch file... StartFTP.bat
(again... batch file creates Finished_FTP_Flag.txt as expected)
"C:\Program Files\WinSCP\WinSCP.com" /ini=nul /command "open ftp://
<myFTP_Site>/" "put \\<myServer>\database\xmit
Here is my MS Access (VBA) command (again... batch file never creates Finished_FTP_Flag.txt