How to get rid of Security Warnings in 2003?

[Stonewall]

Every time I open my 2003 database I get the following message: This file
may not be safe if it contains code that was intended to harm your computer.
I press OPEN and everything is fine. The problem is that this same message
appears in my deployed package to my customer. Each time they go to use my
software they have to answer this message. How can I make it go away for me
and for everyone else who uses my database?

I know it khas something to do with signing the macros and vba code in my
database before I distribute, but I don't know how to do this. I need
detailed instructions, if possible.

Thanks

 

[TC]

Every time I open my 2003 database I get the following message: This file
may not be safe if it contains code that was intended to harm your computer.
I press OPEN and everything is fine. The problem is that this same message
appears in my deployed package to my customer. Each time they go to use my
software they have to answer this message. How can I make it go away for me
and for everyone else who uses my database?

I know it khas something to do with signing the macros and vba code in my
database before I distribute, but I don't know how to do this. I need
detailed instructions, if possible.

Start your database via a script file which sets macro security to Low
for that particular run of that specific database.

Eg. in VBScript:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' set macro security LOW.
o.opencurrentdatabase "full path to your database"
o.usercontrol=true
set o=nothing

HTH,
TC