ACC: Error Message "Internal Database Error -1310"

ID: Q109346

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

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:

Internal database error -1310 has occurred

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 kbusage QryParm
Version : 1.0 1.1 2.0
Platform : WINDOWS
Issue type : kbbug