Solved

Security warning Unsafe expressions are not blocked

Posted on 2007-04-05
15
2,374 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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 85

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 34

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

696 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