Posted:  16 Oct 2009 19:59
	Registered User Currently Offline	Posts:  15 Join Date: Oct 2009
I have a line in my script: if ftpresult eq success begin   # open MMDSBilling to run import process   ftprunprogram "C:\\Program Files\\Microsoft Office\\OFFICE11\\MSACCESS.exe", "C:\\MMDSComm\\MMDSBilling"; If I run the script manually the Access program opens with above line.  However, when script runs from schedule the ftp download runs successfully but the Access program does not run when called.

Posted:  19 Oct 2009 06:34
	Moderator Currently Offline	Posts:  367 Join Date: Nov 2008
Hi Greg, It looks like the script needs to be executed as a specific user. Version 5 supports this feature. You can download a copy of the prerelease version from http://www.sysax.com/prerel/sysaxauto_setup.msi ------------------------------ Windows FTP Solutions Made Simple

Posted:  19 Oct 2009 18:51
	Registered User Currently Offline	Posts:  15 Join Date: Oct 2009
I downloaded the new version and I see the changes included.  However, I still cannot get the MS Access program to open (see above script lines).  What settings should I be using in Creating a task and are the above script lines OK?  Note, the ftp download which precedes the above lines works OK.

Posted:  21 Oct 2009 16:33
	Moderator Currently Offline	Posts:  367 Join Date: Nov 2008
What version of windows are you running this under? It is possible that this could be related to UAC. ------------------------------ FTP Server Solutions Made Simple

Posted:  21 Oct 2009 23:33
	Registered User Currently Offline	Posts:  15 Join Date: Oct 2009
I'm running Windows 7 Ultimate and calling Microsoft Access 2003 Sp3 from your script (see above).  I have discovered that Interactive Services Detection is blocking Access from running.  Is there a solution for this? Thank you.

Posted:  22 Oct 2009 23:50   Last Edited By: sysaxsupport
	Moderator Currently Offline	Posts:  367 Join Date: Nov 2008
There is an applocker feature in windows 7 that controls program execution. There might be a way to configure this so that sysaxftp.exe (the program that executes the script) is granted access. ----------------------------- FTP Solutions Made Simple

Copyright © 2021 Codeorigin, LLC - All Rights Reserved.
RSS 2.0 Atom 1.0