"too complex expression" error message
Posted on 2000-04-27
I've got an Access-97 database that was
autoconverted from an Access 2.0 database.
Every now and then (when the database
is getting too large) i get the error
"This expression is typed incorrectly,
or it is too complex to be evaluated.
For example,a numeric expression may
contain too many complicated elements.
Try simplifying the expression by assigning parts of the expression to
when I try to open a form, or even enter
If I run a "compact database" the
problem dissapears for a week or so,
until the database has grown larger.
Then it pops up again.
What exactly is my problem?
Does this occur because it is an
autoconverted base, or is there
somthing I can do about it?