Thanks for your reply Alex,
So the key to read is:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode
that would be nice, but how to read this key from within vba?
Hi Alex, thanks for this link, it helped me a lot.
So this is what i do is:
Read the registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engines\SandboxMode
If it is 1 or 3 then sandbox mode is activated and unsafe expressions should
be blocked.
If it is 0 or 2 then expressions are evaluated in Access.
So far OK, this works for my computer and some other tests were OK also, so
i rolled out my app and next thing happening is a user contacted me telling
me the registry key on his computer is 1 or 3 but the 'unsafe' expressions
are still being executed. On his computer in Access Tools>Macro>Security is
set to Low, but the registry key did not follow this setting and still is 1
or 3.
So reading this reg key is not reliable enough to know whether Macro
security is set to LOW or not?
Can you, or anyone else explain to why this might happen and how to do it
correctly ?
Hi,
ok, there is one more key for macro security - to set it to Low - you have
to set this key:
HKEY_Current_User\Software\Microsoft\Office\11.0\Access\Security\level
to 1
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
