When I attempt to generate a certain report, I get the message “Query Too Complex” but when I run the query the report is based on, the query runs OK. What does this mean?
A Access 2.0: Access has just exposed one of it’s limitations, it’s 16 bit and therefore stores data into 64K segments, you’ve just filled up one of those segments. Consider making your query a Make-table query or an append query to a temp table then base the report on the table, this will split the processing up a bit and as the query and report are no longer one operation, Access will no longer try to store both into the same 64K segment.
Related Questions
- When I attempt to generate a certain report, I get the message "Query Too Complex" but when I run the query the report is based on, the query runs OK. What does this mean?
- Why do I see the message "There was no significant database activity to run the ADDM" in the Informatinal Findings of an ADDM Report ?
- Why does Windows report the following error message when I run MicroBase?
