1 พฤษภาคม 2555 21:12
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:
Neither of these had any values
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.
1 พฤษภาคม 2555 23:33ผู้ดูแล
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
2 พฤษภาคม 2555 16:40
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.