Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 2nd, 2005, 09:00 PM
Authorized User
Join Date: Aug 2005
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default bypassing security

i want to know what code can i place in my program in order to bypass the security notice it appears on the screen each time access opens it?

Old October 2nd, 2005, 09:02 PM
Friend of Wrox
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post

are you talking about the macro security?


Old October 4th, 2005, 07:31 AM
Authorized User
Join Date: Aug 2005
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts

yes, i guess is macro security.

Old October 4th, 2005, 08:43 AM
Friend of Wrox
Join Date: Oct 2004
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

The problem with Macro Security is that it is tied to the actual installation of Access and cannot be controlled through a database. The idea is to protect your computer from a maliciously coded database.

If you would like to disable this on your computer, just go to Tools - Macros - > Macro Security and then set the security to Low.

If you do this, you just want to make sure you don't open databases sent to you from unknown people.

Old October 13th, 2005, 02:27 PM
Registered User
Join Date: Oct 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to WhoFan

Access 2002/2003 has 'Macro Security' and installs in what is called 'Sandbox Mode' with additional securities against potentially harmful code. First you are directed to upgrade to the Jet database engine and then you get the generic 'unsafe expressions' message.

Mike from Echovue is right that you can disable the message by lowering the security setting, but if you are opening databases from other people/companies and you are not sure whether these are secure databases that may be your best option.

If you are opening your own databases as well, you can create a 'self-certification' digital signature so the messages are not opened when you open your own databases but maintain security when opening others. Chapter 20 in "Access 2003 VBA" by wrox covers the options in great detail.

Also there is an article in the Microsoft Knowledge Base (Q294698) that gives more information about the sandbox mode.

I hope this helps,
Old October 13th, 2005, 02:31 PM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

WhoFan, nice post on sandbox mode. Clicking all the right warning buttons takes you out of that mode.

I didn't know about self certification. I have the book and will look it up. Is that transportable within the organization? Or will that require a formal certification process (if I send the app down the hall, does it work the same as on my PC?)



Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Access Security & Role Based Security robzyc C# 6 April 11th, 2008 02:31 AM
Bypassing login dialog aldwinenriquez ASP.NET 2.0 Professional 1 June 29th, 2006 08:16 AM
System.Security.SecurityException: Security error coolcatjk Pro VB.NET 2002/2003 4 March 2nd, 2006 06:00 PM
Security deys C++ Programming 0 February 2nd, 2006 02:33 AM
Security qa BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 8 June 28th, 2004 11:00 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.