O
Owl
Is it safe to change my Sandbox Registry Value from 3 to 2?
If so, is there anything in particular that I need to be careful about?
If so, is there anything in particular that I need to be careful about?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
Owl said:Is it safe to change my Sandbox Registry Value from 3 to 2?
If so, is there anything in particular that I need to be careful about?
I've had no ill effects. Here's a Microsoft discussion:
http://office.microsoft.com/en-us/access/HA101674291033.aspx
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
O
Owl
Thank you Arvin, firstly for the link to Microsoft Help on the matter - that
is actually where I discovered Sandbox's existence; secondly for your opinion
which I value even more than the Microsoft Office help; and thirdly for the
treasure trove I found in the 3 links below your name - I have saved all of
them to my favourites and when I have time (ha ha! what's that?), I plan to
delve into those exciting treasures, as I do in Microsoft Discussion Groups.
is actually where I discovered Sandbox's existence; secondly for your opinion
which I value even more than the Microsoft Office help; and thirdly for the
treasure trove I found in the 3 links below your name - I have saved all of
them to my favourites and when I have time (ha ha! what's that?), I plan to
delve into those exciting treasures, as I do in Microsoft Discussion Groups.
A
Arvin Meyer [MVP]
Thank you for that. I operate those 3 websites, but there are many other
great ones. Look in Jeff Conrad's links at accessmvp.com, and a huge
selection of links at:
http://www.mvps.org/links.html#Access
and look at Tony Toews' site and Roger Carlson's site for lots more links
and great code.:
http://www.granite.ab.ca/
http://www.rogersaccesslibrary.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
great ones. Look in Jeff Conrad's links at accessmvp.com, and a huge
selection of links at:
http://www.mvps.org/links.html#Access
and look at Tony Toews' site and Roger Carlson's site for lots more links
and great code.:
http://www.granite.ab.ca/
http://www.rogersaccesslibrary.com/
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
O
Owl
Thanks again! I have added these ones to My Favourites too. Oh, if only
there were 96 hours a day! I hope to live another 63 years to drink it all
in!
there were 96 hours a day! I hope to live another 63 years to drink it all
in!
O
Owl
I changed it, but my macro still isn't working and still has 2 of the 3
little yellow triangles. I went back into the Registry and saw that Name:
abDefault; Type: REG_SZ has under Data: (Value not set). Surely this can't
be right? Or can it? And if not, what should I change it to? It didn't say
in Help to make any change there. I can't remember what it said before I
changed the 3 to a 2.
Please, pretty please, help me. I have been struggling with this for more
than a week and I am losing my little mind.
little yellow triangles. I went back into the Registry and saw that Name:
abDefault; Type: REG_SZ has under Data: (Value not set). Surely this can't
be right? Or can it? And if not, what should I change it to? It didn't say
in Help to make any change there. I can't remember what it said before I
changed the 3 to a 2.
Please, pretty please, help me. I have been struggling with this for more
than a week and I am losing my little mind.
A
Arvin Meyer [MVP]
You may not have permissions to change the registry as you are logged in.
Try logging in as the administrator. The following is for Access 2003 which
is on this particular machine, but is similar for 2007 (Office/Access 12)
To change the Macro Security setting to low, you can either write some code
or you can make a change to the Windows Registry for each computer that
needs the new security level. The easiest way is to change the Registry
setting. However, many people are uncomfortable altering their Windows
Registry, and making mistakes can cause serious problems, such as the
inability to reboot the computer. Make sure that you back up the Registry
before making changes, and make sure that you also know how to restore the
Registry from a backup before making changes, too.
The Registry keys that need to be changed or added are:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\SandboxMode
Change the value of this key to 2 if it isn't set there already. (It's the
default.)
Values available for the Sandbox mode:
0 = Sandbox mode is disabled at all times.
1 = Sandbox mode is used for Access applications, but not for non-Access
Applications.
2 = Sandbox mode is used for non-Access applications, but not for Access
Applications. (Default)
3 = Sandbox mode is used at all times.
-------------------
The security level can be changed for either individual users or created for
all users who log onto the computer.
If you need to set the security for an individual user, then you need to
change this key:
\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level
Change the value of this key to 1 for low security. (2 = medium security; 3
= high security)Or for all users on the computer, you need to create this
key:
If you need to set the same security level for all users who log onto the
computer instead, then you need to create this new Registry key:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security\Level
Create the key of type DWORD and set the value to 1 for low security. (2 =
medium security; 3 = high security)
If you'd rather use code to make the change in the security setting for the
current user, then you may copy and paste the code below into a module in
your runtime application so that the user will be able to use the menu to
alter this security setting manually. The subroutine can be called during
the startup of the runtime application or from the click event of a command
button.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
You can thank the FTC of the USA for making this disclaimer necessary.
Try logging in as the administrator. The following is for Access 2003 which
is on this particular machine, but is similar for 2007 (Office/Access 12)
To change the Macro Security setting to low, you can either write some code
or you can make a change to the Windows Registry for each computer that
needs the new security level. The easiest way is to change the Registry
setting. However, many people are uncomfortable altering their Windows
Registry, and making mistakes can cause serious problems, such as the
inability to reboot the computer. Make sure that you back up the Registry
before making changes, and make sure that you also know how to restore the
Registry from a backup before making changes, too.
The Registry keys that need to be changed or added are:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\SandboxMode
Change the value of this key to 2 if it isn't set there already. (It's the
default.)
Values available for the Sandbox mode:
0 = Sandbox mode is disabled at all times.
1 = Sandbox mode is used for Access applications, but not for non-Access
Applications.
2 = Sandbox mode is used for non-Access applications, but not for Access
Applications. (Default)
3 = Sandbox mode is used at all times.
-------------------
The security level can be changed for either individual users or created for
all users who log onto the computer.
If you need to set the security for an individual user, then you need to
change this key:
\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level
Change the value of this key to 1 for low security. (2 = medium security; 3
= high security)Or for all users on the computer, you need to create this
key:
If you need to set the same security level for all users who log onto the
computer instead, then you need to create this new Registry key:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security\Level
Create the key of type DWORD and set the value to 1 for low security. (2 =
medium security; 3 = high security)
If you'd rather use code to make the change in the security setting for the
current user, then you may copy and paste the code below into a module in
your runtime application so that the user will be able to use the menu to
alter this security setting manually. The subroutine can be called during
the startup of the runtime application or from the click event of a command
button.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.
You can thank the FTC of the USA for making this disclaimer necessary.
O
Owl
Thank you very much for your response. However, before I do any of that,
please will you answer my question in my previous entry because that issue is
worrying me.
It is my own laptop and nobody else ever uses it.
please will you answer my question in my previous entry because that issue is
worrying me.
It is my own laptop and nobody else ever uses it.
A
Arvin Meyer [MVP]
If it's your own machine, the easiest way to deal with the problem is
through the GUI user interface. Just set the Macro security to Low. Or
reread, the information below. If the key doesn't exist, you need to add it.
Otherwise, just change it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
through the GUI user interface. Just set the Macro security to Low. Or
reread, the information below. If the key doesn't exist, you need to add it.
Otherwise, just change it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
Ask a Question
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.