 |
| 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
|
|
|
|
October 2nd, 2005, 09:00 PM
|
|
Authorized User
|
|
Join Date: Aug 2005
Location: , , .
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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?
|
|
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
|
|
are you talking about the macro security?
Kevin
dartcoach
|
|
October 4th, 2005, 07:31 AM
|
|
Authorized User
|
|
Join Date: Aug 2005
Location: , , .
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
yes, i guess is macro security.
|
|
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
|
|
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
|
|
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
|
|
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
|
|
October 13th, 2005, 02:31 PM
|
|
Friend of Wrox
|
|
Join Date: Mar 2004
Location: Washington, DC, USA.
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?)
Thanks,
mmcdonal
|
|
Similar Threads
