ACC: Errors When RunSQL Action Argument Exceeds 256 Characters

ID: Q109355


The information in this article applies to:


SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

The RunSQL macro action argument can accept up to 256 characters. However, you receive no error message that tells you when you have exceeded this limit. Instead, the SQL string is truncated at 256 characters and Microsoft Access attempts to parse the first 256 characters. This can cause a variety of error messages, including:

The error message you receive depends on where the string was truncated.


CAUSE

Note that these errors occur when you manually enter a SQL string with more than 256 characters. If you paste a string with more than 256 characters, Microsoft Access will notify you that you have exceeded the limit with the following error message:

Text would be too long; change canceled.


STATUS

This behavior no longer occurs in Microsoft Access version 7.0.


RESOLUTION

Paste in the string to confirm the error, and then shorten the SQL string to less than 256 characters.

Additional query words: macros


Keywords          : kbusage McrArg 
Version           : 1.0 1.1 2.0
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: March 30, 1999