Too Comple to Evaluate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have recently converted a number of Access97 databases to Access2002. The converted databases run fine on any machine running Windows XP Pro but I continually get the following error message on any machine running Windows 2000 Pro:

"The expression is typed incorrectly, or is too complex to be evaluated."

I haven't been able to figure which expression is causing the problem but I am more concerned that it will run on some machines and not others.

Any assistance will be greatly appreciated.
 
Hi Shannon,

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!

Resolution

Click Start\Run on the problem machine.
Type "Regedit" (without quotation marks) in the Open box and then click OK.
In the registry window, locate the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines
What is the value of SandBoxMode item in the right pane?
If the value is not 2, double click the item "SandBoxMode" in the right
pane and change the value to 2.
Close the registry window and reboot the machine.
Re-try to run a search on the database in Access, what is the result? Does
the same issue still occur?
What this does:

Apparently, it has to do with server security:

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.

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top