ACC2000: SQL View of a Query Is Empty or Causes an Error (251401)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q251401
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you open a query in SQL View in the Microsoft Access user interface, you may receive the following error message:
The text is too long to be edited.
After you click OK to close the error message, the Query window opens, but it is empty.

If you programmatically open the query in SQL View, you do not receive the error message; however, an empty Query window opens.

CAUSE

The maximum number of characters for a SQL statement has been exceeded. The number of characters in a SQL statement is limited to approximately 64,000.

RESOLUTION

Split the existing query into multiple queries, and then run each query separately.

REFERENCES

For more information about query limits, click Microsoft Access Help on the Help menu, type microsoft access specifications in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kberrmsg kbprb KB251401
©2004 Microsoft Corporation. All rights reserved.