Why does my application come up talking about Unsafe Expressions, and
asking whether I want to disable them? And how do I stop it from doing so?
There are several ways to do this. You can set the Macro Security to Low (which isn't recommended by MS, but many people
do it) or you can sign your code, enable Sandbox mode, and instruct your users how to remove these warnings. See the
links below for more infomration on Digital certificates and signing code:
http://office.microsoft.com/en-us/access/HP010397921033.aspx
http://office.microsoft.com/en-us/access/HP010446121033.aspx
http://office.microsoft.com/en-us/access/HA011225981033.aspx#0 (see the "How do I prevent these messages from appearing
each time a file is opened?" section here
There are also registry keys you can apparently manipulate on the end user machine that will set the Macro security to
Low ... some have advocated doing this, then opening your application, then resetting the security to the previous level
when the app closes (perhaps via a batch file or vbScript or small VB program). While this would work, in some cases
this might be viewed as circumventing security (in the case of my clients - NASA, NRL, and other government research
labs) this is the case - I know, I asked them, and they told me "If your software changes ANY security settings we'll
stop using it, and you'll deploy another piece of software to us again." Suffice it to say that was enough to convince
me ...
Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
