Bypassing MS Access Security Warning

[jackiesturner]

I'm a total newbie and don't know VBA...so please tell me I'm just missing something really dumb!

I have a maro set up in Access that will do everything I need done. I'm using Macro Scheduler to launch Access. I then run an autoexec macro within Access. After that has run, Macro Scheduler kicks in again to ftp the newly created file to a site.

Problem is...I can only get around that Access security warning if I manually run the macro. When it's on a timer, my waitwindow doesn't cut it. It hangs up at the window that reads "Security Warning - "file name" - This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?". It then provides me "Cancel", "Open" and "More Info".

Can you please review my script and let me know what I'm doing wrong??!!

ExecuteFile>Z:\TRAC_Updates\TRAC.mdb
Press Tab
Press Enter
WaitWindowOpen>Security*
WaitWindowClosed>Microsoft Access*
Run Program>C:\Program Files\PyroBatchFTP\pyrobatchftp.exe
WaitWindowOpen>PyroBatc*
Press F5
[/code]

[jackiesturner]

I added a digital signature to the file. I think that fixed the problem, though I won't know until tomorrow morning whether or not the macro runs successfully. If anyone has comments about my script, please feel free to post anyway. Thanks!

[Me_again]

Don't you need

Press Tab
Press Enter

After

WaitWindowOpen>Security*

?

[jackiesturner]

In one of the previous posts, I read that I needed to put the Press Tab/Press Enter BEFORE the WaitWindowOpen or else it would forever wait. It seems that either before OR after will work fine when I activate the macro...but both will hang up on the security warning (or did until I added the digital signature). This part of where to add the Tab/Enter is very confusing to me...