Unsafe expression security message

[bluemoon9]

My database is built on MS Access 2009 and when I click on the database, it prompted the security warning message: "Security Warning Unsafe Expressions are not blocked. Do you want to block unsafe expression? Answer options: Yes, No, Help". If I click on No, the next time when I open the database, this message would show up again. If I click Yes, then this message won't show up again. My question is if I click Yes, would it affect my database functionality? or is there a code that I could add into the backend of the database so that this message won't show up.

thanks!

bluemoon

[RuralGuy]

I have not heard of Access 2009. Are you sure you have that correct? I take it this is a split application (BackEnd/FrontEnd)?

[NeoPa]

If you block unsafe expressions then your db functionality will be severely reduced yes.

I'm not familiar with the security setup of Access 2007 (or 2010 if that's what you have), but I know that signing your projects can help there. See Code Signing for instructions on that, but be aware, though these instructions give details of each step, they may be complicated for some.

[bluemoon9]

@RuralGuy
I meant 2003. sorry for the typo.
bluemoon

[Jerry Maiapu]

@bluemoon9
To stop the message from popping I think you should go to Tools-Macro-Security.. and Select Low radio button and that message will disappear 4-ever.

Note: **Read and understand the risks involved in enabling this option***

[RuralGuy]

I'm pretty sure Jerry is correct. It was a security "feature" put in ac2003 and requires either setting the Security to low or a digital certificate. The feature was replaced with the Trusted Location in ac2007.

[NeoPa]

Jerry Maiapu: To stop the message from popping I think you should go to Tools-Macro-Security.. and Select Low radio button and that message will disappear 4-ever.

Note: **Read and understand the risks involved in enabling this option***

I hate to comment on another member's suggestion, but I would be very careful indeed before following this advice. In fact, I'd never suggest anyone follow this advice as it would leave your whole system open to malicious software.

As far as the trusted location goes, I'm not sure that replaced Digital Certificates as such, although it can make them unnecessary in certain circumstances (particularly for one's own code). In truth, I don't know this whole area too well, but I have had some recent experience working with a certificated database on somebody-else's Access 2007 setup, so I know it still works.

[RuralGuy]

NeoPa, you are of course correct. I should have been more careful with my words. As for low security setting, It seems to me that that would make it just like ac2002 which did not have that feature.

[NeoPa]

I never used (or even saw I think) Access XP (2002), but I'm pretty sure Access 2000 had it. I thought Access 97 was the last without it. I wish I could check for you, but I can't think of a PC we have that still uses it.

[NeoPa]

I just went around to have a look funnily enough, and every PC is neatly powered off and their owners either gone home for the afternoon or decamped to the canteen where the match is about to start.

I'll post if I can confirm - but not until at least the match has finished :D