MikeC14081972
Programmer
Hi,
I'm using Access 2007 and have a module that creates a ftp script at runtime and then executes a .bat file passing in the name of the script to run.
The .bat file looks like
The ftp script looks like
The above works as expected and sends the file via ftp to the serverwhen I run the shell command from with Access and the user is shown the completion message as my VBA code will halt whilst the SHELL process is still running then continue on comletion.
However if I change the password to an invalid one (as part of a test) the ftp script will continue to run through till the end and then quit. Leading the VBA code to assume it has completed correctly.
Is there anyway to either stop the script file completing if there is an issue or for Access to check the script ran correctly?
Thanks in Advance.
Mike
I'm using Access 2007 and have a module that creates a ftp script at runtime and then executes a .bat file passing in the name of the script to run.
The .bat file looks like
Code:
ftp -s:{script file} {server name}
The ftp script looks like
Code:
{Username}
{Password}
cd {destination on server}
put {filename to send}
bye
The above works as expected and sends the file via ftp to the serverwhen I run the shell command from with Access and the user is shown the completion message as my VBA code will halt whilst the SHELL process is still running then continue on comletion.
However if I change the password to an invalid one (as part of a test) the ftp script will continue to run through till the end and then quit. Leading the VBA code to assume it has completed correctly.
Is there anyway to either stop the script file completing if there is an issue or for Access to check the script ran correctly?
Thanks in Advance.
Mike