M
Matt
I have a report inside of an Access db file that I need to run in a regular,
automated fashion. I have found a very simple way to do this via the start
command, inside of a batch file:
start /wait msaccess.exe "<Access File>" /x "<Macro>"
The Macro calls the report. This works fine, however, I always seem to get
a security warning when I open up the mdb file - this prompt ties up the
automation.
Initiallly I get the security warning :
"This file may not be safe if it contains code that was intended to harm
your computer......" (1)
I do some reading, and find that I need to change the macro security to low
and hit OK. So I do this.
Now I get:
"Unsafe expressions are blocked. You can configure your computer to allow
all expressions to be evaluated. Do you want to allow the evaluation of
potentially unsafe expressions?" (2)
If I say no, this seems to work. I can close the mdb file and reopen it
without getting any security warnings. However, if I close the application,
then reopen the mdb file, I get message (1) again. When I check the macro
securtiy level, it is at
medium again. In other words, it has reverted back to its default vaule.
When I last closed the app, I saved this value to low.
If I respond yes to message (2), I get a message saying I must restart app
for settings to take effect. When I reset, I get another form of message (2)
again.
This process goes on and on, without a resolution. Basically, I can't seem
to modify the security settings inside of Access so that all secuirty
warnings are avoided in the future when I reopen the app. Any help would be
appreciated. Thanks.
- Matt
automated fashion. I have found a very simple way to do this via the start
command, inside of a batch file:
start /wait msaccess.exe "<Access File>" /x "<Macro>"
The Macro calls the report. This works fine, however, I always seem to get
a security warning when I open up the mdb file - this prompt ties up the
automation.
Initiallly I get the security warning :
"This file may not be safe if it contains code that was intended to harm
your computer......" (1)
I do some reading, and find that I need to change the macro security to low
and hit OK. So I do this.
Now I get:
"Unsafe expressions are blocked. You can configure your computer to allow
all expressions to be evaluated. Do you want to allow the evaluation of
potentially unsafe expressions?" (2)
If I say no, this seems to work. I can close the mdb file and reopen it
without getting any security warnings. However, if I close the application,
then reopen the mdb file, I get message (1) again. When I check the macro
securtiy level, it is at
medium again. In other words, it has reverted back to its default vaule.
When I last closed the app, I saved this value to low.
If I respond yes to message (2), I get a message saying I must restart app
for settings to take effect. When I reset, I get another form of message (2)
again.
This process goes on and on, without a resolution. Basically, I can't seem
to modify the security settings inside of Access so that all secuirty
warnings are avoided in the future when I reopen the app. Any help would be
appreciated. Thanks.
- Matt