Running/Closing an .exe file??

[MattS]

I have a database performing various tidy up/admin routines, which is scheduled and run very early in the morning (6am). I wanted it to fire off an e-mail to a few people to confirm when the routines had successfully run, but ran into problems with Outlook opening up a security message ("A program is trying to send an e-mail......."), and waiting for a prompt (thereby holding up the rest of the routines).

I have now obtained an .exe file which, when run, overrides this message and allows the DB to run through.

This works perfectly well, but for tidyness and good-practice I would like to close the .exe after the e-mails are sent. Any ideas on how to do this?

 

[Fizzio]

Does it have any command line options?

ps, interested in the .exe

 

[MattS]

Does it have any command line options?

???? Not sure what you mean.

I know very little about this .exe file, my skills being Access only unfortunately. Obtained it from a colleague who also develops Access, and it was written for him by somebody that has now left the company.

When triggered, it just runs in the background. The Outlook message still appears, but requires no user action.

 

[MattS]

Bit more info, & another question!

Ok, the .exe file seems to originate from a freeware program called AutoIt - www.hiddensoft.com/AutoIt

Currently, I just trigger the .exe and leave it running, so that when the scheduled DB kicks in there are no problems.

I was going to try and trigger the file when my DB opened and the routines started, using:

Application.FollowHyperlink "\\ServerName\FileName.exe"

But I get a Microsoft Office prompt asking me if I want to run it or not.

So now, I have two problems. How to trigger the .exe without being prompted, and (my original question) how to stop it when the admin routines have run??

Thanks for any help.

Matt.

 

[Fizzio]

Why not use the ActiveX version then you can script it with VBScript (apparently!)