O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

22.5. Summary

Microsoft takes security seriously, and as a result it's created some nuisances for you to deal with. However, the nuisances aren't difficult. Sandbox mode helps protect you from malicious attacks on your computer by blocking some functions from SQL queries and other expressions. Because sandbox mode doesn't affect VBA, you can work around these protections by defining Public functions to execute from queries where necessary. You can also use Public functions or register ActiveX controls if the properties of those controls are blocked.

You can use the Office Trust Center and Disabled mode to protect you from malicious databases. Both features provide the capability to protect your users and yourself. Because of the power of Access and its increasingly widespread usage, this added protection is a good thing.

You can work around the security warnings in a variety of ways, including trusted locations, using Visual Basic scripts to start your databases or digitally signing the databases you publish. Yes, all this means more effort. But what price do you put on security? It's really a small price to pay for some very effective insurance.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required