I updated from A2K to A2010 recently and found that in order to use
existing right button clicks (for popup menus) I needed to change the
SandBoxMode in the Registry from 3 to 2. This worked fine.

However recently this value has reverted, unexpectedly, to 3 on all 20
machines. Not sure why. Maybe the systems man had updated something.

However instead of going to every machine and using RegEdit I wondered
whether I could do this from code.

I would like, when opening the Access database to check the value of
SandBoxMode and, if necessary, change it to the required value.

Is this possible? and if so, how do I:
1 examine the value of SandBoxMode
2 change its value.

I know that it is at:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\14.0\ Access Connectivity
Engine\Engines\SandBoxMode

I simply want to be able to change it from code.

Jim

On Mon, 4 Jul 2011 07:05:04 -0700 (PDT), Jim Devenish
<internet.shopping (AT) foobox (DOT) com> wrote:

See http://access.mvps.org/access/api/api0015.htm for sample API code
to read the registry. Search at http://vbnet.mvps.org/ for lots of
sample API code including how to update/write the registry.

The problem though is HKEY_LOCAL_MACHINE which requires admin
privileges to update. You and your users almost certainly won't be
able to change that value. You will need to talk to your system
administrators.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/