Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
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
Location: , , .
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default bypassing security

Hi,
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
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

are you talking about the macro security?

Kevin

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

yes, i guess is macro security.

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

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.

Mike
EchoVue.com
 
Old October 13th, 2005, 02:27 PM
Registered User
 
Join Date: Oct 2005
Location: Brea, CA, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to WhoFan
Default

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,
Bryan
 
Old October 13th, 2005, 02:31 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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?)

Thanks,

mmcdonal




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.