Turn off code Security Warning Access 2010 (1 Viewer)

This soltuin seemed to work just fine:
http://www.accessmvp.com/TWickerath/articles/trust.htm


Tried all of these first - without success - the above link solved it.
Microsoft Site with graphic
http://social.technet.microsoft.com/Forums/en-US/officesetupdeployprevious/thread/5e6b9f3e-eecc-4b79-880e-f56131dc44fa/

Discuss Access 2010 32 bit running on 64 Bit OS
http://answers.microsoft.com/en-us/...messages/ff705cc1-32f6-414f-af0e-ac1271661417

Discussion of Sandbox settings:
http://www.vb123.com/Toolshed/04_docs/sandbox.htm

A VBA subroutine found on this fourm (but may be for earlier version than Access 2010)
http://www.access-programmers.co.uk/forums/showthread.php?t=162742



Instructions for Registry Key for a survey application written in Access 2010
http://www.latibiz.com/htg/index.html?005_06.htm



How to Modify REGistry Keys
http://support.microsoft.com/kb/310516




The above discuss the security warning when Access starts up This is how to turn off warnings when running code
Manual User Process
http://ageesw.com/MACRO.htm

Using Macro's
Macro SetWarnings False
Macro Run Query "Delete Query Name"
Macro SetWarnings True

Using VBA code
DoCmd.SetWarnings False
DoCmd.OpenQuery "QueryName"
DoCmd.SetWarnings True

Rx_ thank you for this valuable post.

All these solutions work for fixed settings. I wonder i someone can help me with the following:

We have an access client that we provide to multiple sites and multiple users. Some still use Access 2003, other 2007, and currently more and more 2010. We want our code to be protected (that is the VBA code). We do not have access to all the user machines where the client runs on. That is, we CANNOT disable the security warning for the users in their systems.

Now here is the real issue: Once Access starts and the security warning pops up, the client is UNPROTECTED. That means, anyone with some Access knowledge can get to the code. Does anyone know how to prevent this?

Thank you in advance!!!