Solved

Security warning Unsafe expressions are not blocked

Posted on 2007-04-05
15
2,328 Views
Last Modified: 2008-09-25
How do I get this message? This comes up when I first open Access.

Thanks
0
Comment
Question by:Mike Eghtebas
15 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 200 total points
ID: 18859778
Mike,
It sounds like you just started using A2K3?

If you set the macro security level to low (not recommended) you can get rid of it.  Otherwise you can
- Deal with clicking throught the warnings
- Digitally sign your project
...
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 200 total points
ID: 18859780
Because the sandbox mode is set to LOW ...

Check this link ...

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_22468746.html

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18859792
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 75
ID: 18859797
0
 
LVL 75
ID: 18859836
To minimize issues ... leave the setting Low.  Med and High are a false sense of security in A2003.

I know mbiz and I do not agree on that, so I guess we agree not to agree :-)

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18859891
LOL!  I'm not totally disagreable ......
My issue with that (especially on a public forum) is that many workplaces, including the US Govt. (I'm pretty sure this is globally enforced now) consider the low setting in violation of security policies.

Regardless of the sense of it.
0
 
LVL 75
ID: 18859933
L  O   L ....

Well ... I agree with that then ...
Interesting that here at So Cal Edison ... Low is not enforced (yet) on the few systems that have O/A2003.  Most users however are on Office/Access XP.

Seems all these Sandbox issues are suddenly coming up ... weird.  I think I will stick with my two large cat litter boxes and my four indoor cats ... no major issues there, lol.

mx
0
 
LVL 75
ID: 18859956
ok ... mbiz ... I have a suggestion re "level to low (not recommended) you can get rid of it."

Maybe you could insert ("not recommended by FDA, FCC, CIA, FBI and other Gov't institutions") ... that would clarify it ... what do you think?  Then ... I wouldn't feel compelled to always counter that, lol ...

yes/no ?

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18860013
How about:

Level to low -- Possibly Not recommended (** check into your company/organization's security policy)

** Footnote:  Added to keep mx in check

:-)
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 100 total points
ID: 18860020
You get these messages because, as others have said, your macro security is set to Medium or higher. You can set to Low and remove the warnings, as others have said, but that could potentially leave your machine open to attacks (not highly likely, but the threat is still there).

MX has provided some good links to helping you understand why this occurs, and what to do about it, but I'll summarize.

It's a little more involved that just signing your code. To remove the warnings you would (a) insure that your machine is using the Jet 4.0 Service Pack 8 for you particular OS, (b) enable Sandbox mode, (c) purchase (or make) a certificate and install it on your machine, (d) digitally sign your application  and (e) choose the correct answers the next time your app opens. If you do these things, then your application will not display the security warnings again.

If you plan on deploying this to others, then you'll probably need to purchase a commercial certifcate (like from www.instantssl.com or some other trust authority). You'd use this cert to sign your project, then deploy it to others. When others attempt to open your file, they'll get a prompt to accept and install your certificate; after they do this, then they'll be able to open your file without warnings IF they already have Sandbox mode enabled. If not, then nothing you do will stop the security warnings.

Again, the link that MX provided will go into much greater detail, but perhaps this will help.

0
 
LVL 75
ID: 18860093
mbiz.  Excellent. Make it happen.  'check' mate :-)

mx
0
 
LVL 33

Author Comment

by:Mike Eghtebas
ID: 18862398
On my laptop, I can change the security level to low, but cannot at the companies computer. Need to talk to IT manager.

Thank you all.
0
 
LVL 75
ID: 18862587
You're welcome ...

mx
0
 
LVL 61

Expert Comment

by:mbizup
ID: 18862961
Glad to help
0
 
LVL 75
ID: 18864614
Guess we can all agree this was win-win-win-win (aka win4x) :-)

mx
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question