Solved

MSAccess, unsafe expressions??

Posted on 2004-04-21
7
2,679 Views
Last Modified: 2008-02-20
I am getting a warning on my Access Database when I open it that says " Security Warning - Unsafe expressions are not blocked" and gives the option to unblock or not. When I select no it brings up another warning box whichg states I should download Jet service pacvk 8 or above. I have downloaded the service pack and installed it but it is no different!
I managed to get rid of the warnings by lowering the macro security level to "LOW" which I am not happy about and wondered if there was a better solution to the problem.  I believe that I can digitally sign the database file and this will also remove the warnings, is this true? and if so how do I do it!!

Thanks

Regards Malc
0
Comment
Question by:Malc2003
  • 2
  • 2
  • 2
7 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10876526
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 250 total points
ID: 10876530
0
 

Author Comment

by:Malc2003
ID: 10882224
I didn't really want to edit the registry, I wanted to try and sign the database file, if this is possible and if it will work.  Then if it doesn't work I may try the registry edit to turn off sandbox mode. Do you know what effect turning off sandbox mode will have? Does it open the computer up to unsafe code? If so it is no better than me turning the security level down.  I would rather make sure the file was ok and then digitally sign it?! but i have no idea how to or if that would solve the problem.

Thanks

Malc
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 50

Expert Comment

by:Steve Bink
ID: 11956448
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Accept - rockiroads

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

RoutineT
EE Cleanup Volunteer
0
 

Author Comment

by:Malc2003
ID: 11985781
By all means force the accepted answer but I haven't accepted an answer myself simply because I was unable to find an acceptable solution to the problem from the answers given.

Thanks

Regards Malc
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 11991757
My recommendation for closing this question was based on rocki posting the Microsoft recommended solution for this issue, which would solve the problem.  The description of what effects enabling/disabling sandbox mode has on Access (your secondary questions regarding rocki's post) can be found from those two links.  

Digital signing is a step above and beyond what is necessary for normal Access projects, and will only guarantee a solution to your problem is the certificate is signed by a safe (or "trusted") site.  It also involves either a) creating a certificate with a third party such as Verisign, or b) implementing your own CA, and creating and implementing your certificates there.  Additionally, this does not guarantee supression of the warning boxes on a distributed application, since the recipient would also be required to accept the certificate as valid.  In an intranet environment, it is much easier to simply add the subnet to your list of trusted sites in IE.  There is a small app that comes with Access which does essentially that in a digital cert format.  For more information on it, and on digital signatures in general, try this link:

http://support.microsoft.com/default.aspx?scid=kb;en-us;217221

I apologize for the confusion.  You can post a request in the Community Support TA to have an admin look at this question.  I do not know if they can reopen a closed question, but they should be able to work out a suitable resolution for you.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

912 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now