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:
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.
Additional query words: blank prb
Keywords: kberrmsg kbprb KB251401
