This Expression is Typed Incorrectly, or it is too Complex to be Evaluated

Background

 

In various points throughout the program you may receive the error "This expression is typed incorrectly, or it is too complex to be evaluated" followed by another message "Object invalid or no longer set".

Microsoft Technical Support provided the following resolution.  The fix requires modification of your computers registry settings.

  
Please proceed with caution!

 

 

Solution

 

  1. Click Start\Run on the problem machine.

  2. Type "Regedit" (without quotation marks) in the Open box and then click OK.

  3. In the registry window, locate the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines

  4. What is the value of SandBoxMode item in the right pane?

  5. If the value is not 2, double click the item "SandBoxMode" in the right pane and change the value to 2.

  6. Close the registry window and reboot the machine.

  7. Re-try to run a search on the database in Access, what is the result? Does the same issue still occur?

 

To make your system more resistant to malicious attacks while at the same time making it possible for older applications to keep running, the operation of the Sandbox mode has changed in the Jet update so that it is fully under your control.

You can set the key to the following values, with 0 (zero) being most permissive and 3 being least permissive:

Setting Description
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. (This is the default value.)
3     Sandbox mode is used at all times.