I am trying to automate a report to run at night. I have created a batch file that will run a macro each night. But, when Access starts and loads my database I get a Security Warning [ This file may not be safe if it contains code that was intended to harm your computer]
I have tried to use a Sendkeys command to send an 'O' to go ahead and open the database but it doesnt work.
Also, my report goes to a pdf converter and it asks for a file name. I just want the macro to accept the default and continue.

How do I do this?

Thanks in advance
KD

The simplest way is to set the Macro Security level to Low:

From the Menu Bar, go to Tools > Macro > Security. Set the Security Level to Low.


However, if Macro Security is of a concern, you may want to digitally sign your project. This should get you past the warning.