Microsoft KB Archive/251401

= ACC2000: SQL View of a Query Is Empty or Causes an Error =

Article ID: 251401

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.

