Too complex to be evaluated

[Shannon]

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.

 

[Ken Snell]

see reply to your duplicate post in microsoft.public.access newsgroup.

--

Ken Snell
<MS ACCESS MVP>

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.

 

[Pat Hartman]

The normal culpret when a db works in one environment but
not in another is the references. Open any code module
and choose Tools/References. If there is actually a
reference marked MISSING, uncheck it, close, reopen and
check it again. The likely problem library is DAO.

-----Original Message-----
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.