Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: SQL View of a Query Is Empty or Causes an Error

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

View products that this article applies to.

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).

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Resolution

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

↑ Back to the top

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.

↑ Back to the top

Keywords: KB251401, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 251401
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 298