Microsoft KB Archive/251401

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 16:15, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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.

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