Cannot Disable Sandbox Mode Access 2007
-
Tuesday, May 01, 2012 9:12 PM
This is the first time I’m posting to this site, any help will be appreciated.
I’ve run in to a show stopper for our conversion.
We are converting from Access 2000\Metaframe 1.8\Windows Server 2000 to
Access 2007\Metaframe Presentation Manager\Windows Server 2008.
We have a number of mdbs that we are getting the error message:
“Access failed to evaluate one or more expressions because ‘DoCmd’ was referenced in an expression. Only functions and properties that are considered to be safe are allowed in expressions when Access runs in sandbox mode.”
I checked the registry key for :
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines and the entry was not there.
What was there was:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\MsoExample\A\1033
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\MsoExample\B\1033
Neither of these had any values
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\User Settings\
XDocs_XMLEditVerbHandler
This had two values Count = 1 and Order = 1
I added the entry:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\12.0\Access Connectivity Engine\Engines\SandboxMode
I tried running with SandboxMode = 2 (sandbox mode is used for non-Access programs, but not for Access), SandboxMode = 0 (sandbox mode disabled at all times) and SandboxMode = 3 (Sandbox mode is used at all times) and SandboxMode = 1 (sandbox mode is used for Access, but not for non-Access programs).
No matter what the setting I still get the “Access failed to evaluate one or more expressions because ‘DoCmd’ was referenced in an expression. Only functions and properties that are considered to be safe are allowed in expressions when Access runs in sandbox mode.” Errors.
I have no idea where to turn to or what a next step to trouble shooting this would be.
Any assistance will be greatly appreciated.
All Replies
-
Tuesday, May 01, 2012 11:33 PMModerator
Try http://answers.microsoft.com/en-us/office/forum/access or
http://social.technet.microsoft.com/Forums/en-us/office2007deploymentcompatibility/threads
The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP- Proposed As Answer by Ed Price - MSFTMicrosoft Employee, Owner Wednesday, May 02, 2012 5:17 AM
- Marked As Answer by Hall,FE Wednesday, May 02, 2012 4:34 PM
-
Wednesday, May 02, 2012 4:40 PM
Thank you.
I searched the first link you gave me for Sandbox Mode and found out that the SandboxMode key is located in a a different location for a 64bit machine. It is located at:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines
I changed the value from 3 to 2. I no longer get the error message.
Again, thanks for you help.
Frank