Unsafe expression security message

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • bluemoon9
    New Member
    • Oct 2008
    • 56
    #1

    Unsafe expression security message

    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
    Tags: None
    • RuralGuy
      Recognized Expert Contributor
      • Oct 2006
      • 375
      #2
      I have not heard of Access 2009. Are you sure you have that correct? I take it this is a split application (BackEnd/FrontEnd)?

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32653
          #3
          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.

            Comment

            • bluemoon9
              New Member
              • Oct 2008
              • 56
              #4
              Originally posted by 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)?
              I meant 2003. sorry for the typo.
              bluemoon

                Comment

                • Jerry Maiapu
                  Contributor
                  • Feb 2010
                  • 259
                  #5
                  Originally posted by bluemoon9
                  I meant 2003. sorry for the typo.
                  bluemoon
                  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***

                    Comment

                    • RuralGuy
                      Recognized Expert Contributor
                      • Oct 2006
                      • 375
                      #6
                      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.

                        Comment

                        • NeoPa
                          Recognized Expert Moderator MVP
                          • Oct 2006
                          • 32653
                          #7
                          Originally posted by Jerry Maiapu
                          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.

                            Comment

                            • RuralGuy
                              Recognized Expert Contributor
                              • Oct 2006
                              • 375
                              #8
                              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.

                                Comment

                                • NeoPa
                                  Recognized Expert Moderator MVP
                                  • Oct 2006
                                  • 32653
                                  #9
                                  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.

                                    Comment

                                    • NeoPa
                                      Recognized Expert Moderator MVP
                                      • Oct 2006
                                      • 32653
                                      #10
                                      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

                                        Comment

                                        Previous template Next
                                        Working...