B
berty
I have an access database that use linked tables to an MS
SQL server.
In the DB i have a query that contains calculated fields
one of which uses multiple IIF statements. This currently
works fine.
However, i wish to add one more IIF statements, I add it
as normal save it and the query executes OK.
The problem is when i try and change any data in the
query either manually or via a form I get the "System
Resource Exceeded" error, so then the query does not
update any changes.
If I take out the extra IIF it works fine again!
what does this error mean and is there a way to solve
this problem?
SQL server.
In the DB i have a query that contains calculated fields
one of which uses multiple IIF statements. This currently
works fine.
However, i wish to add one more IIF statements, I add it
as normal save it and the query executes OK.
The problem is when i try and change any data in the
query either manually or via a form I get the "System
Resource Exceeded" error, so then the query does not
update any changes.
If I take out the extra IIF it works fine again!
what does this error mean and is there a way to solve
this problem?