Article ID: 109346
Article Last Modified on 5/6/2003
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q109346
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you run a large query (about 25K or more in size), you may receive the following error message even if the SQL statement is correct:
CAUSE
This error is caused by an out of memory condition in an internal memory segment.
RESOLUTION
Break up large queries that generate this error into several smaller queries.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0, 1.1, and 2.0. This behavior no longer occurs in Microsoft Access version 7.0.
Additional query words: queries oom
Keywords: kberrmsg kbbug kbusage KB109346