Set the Sandbox
This requires modifying the System Registry. To do this you will need ADMINISTRATIVE rights. The Registry SandBoxMode status is blocking execution of FPS executables from within Access. We will lower the Registry SandBoxMode setting to allow full execution of FPS utilities.
These updates may not be permanent. Many Microsoft Updates will reset this value to "3" and the user will then need to update these values again.
UPDATE: Adobe updates appear to be the function resetting SandBoxMode
Steps Required to Set the SandBoxMode
Go to Windows Explorer and find the C:\Windows folder as shown in the following figure.
Scroll down within the Windows folder until you find “regedit.exe”. Then double-click on “regedit.exe” to cause it to open. You can also type “regedit” into the windows run command.
Within the Registry Editor gradually open each folder in the following series:
32-Bit and 64-Bit:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines
In the inner-most folder you will find the SandBoxMode switch. It will likely be set to “3”. You will need to set it to “2”. For further explanation read the article on Microsoft’s website
Views 1, 2 and 3 follow as snap-shots at each level within the Registry for the 32 bit configuration. The RegEdit “Find” tool can also be used to locate the SandBoxMode switch.
Note: If you have a 64 bit install or dual install, there may be more than one SandBoxMode switch in your system registry.
Suggestion: The RegEdit "Find" tool can also be used to locate "SandBoxMode". Simply click on the "My Computer" at the top of the registry tree on the left and select "edit" and "find". Search for "SandBoxMode". Once you have updated the value found press "F3" or "edit" and "Find Next" to continue until all "SandBoxMode" values have been updated.
Right-click the “SandBoxMode” item to get the “Modify” option to appear. Then click on “Modify” to get the dialog box “Edit DWORD Value”.
Change the “Value data” to “2” and click “OK”.
The final result should be the value “2” in the “SandBoxMode” data field.
Advanced Users Guide
Use at your own risk!!
It is also possible to create a script to take care of this automatically. if you know what the Keys are for your setup then you can create a batch file that sets the sandbox values automagically. The following commands will update/create the keys. YOUR SETUP MAY NOT CONTAIN ALL OF THESE OR MAY CONTAIN MORE/DIFFERENT KEYS.
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines" /v SandboxMode /t REG_DWORD /d 2 REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines" /v SandBoxMode /t REG_DWORD /d 2 REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines" /v SandBoxMode /t REG_DWORD /d 2
REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines" /v SandBoxMode /t REG_DWORD /d 2 REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines" /v SandBoxMode /t REG_DWORD /d 2 REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines" /v SandBoxMode /t REG_DWORD /d 2