[AccessD] Need help with a query

John W. Colby jwcolby at gmail.com
Thu Apr 2 09:09:19 CDT 2015


Using a sql string in a source property of a control or form is where I 
always ran into issues.  No idea whether that is now opened up beyond 2K 
characters.

John W. Colby

On 4/2/2015 8:45 AM, Heenan, Lambert wrote:
> Interesting. I could swear I hit the limit recently with a large, comma delimited In() clause which would not run in JET but was OK as pass-through query.
>
> Lambert
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray, Don
> Sent: Wednesday, April 01, 2015 6:14 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Need help with a query
>
> Surprised by a limit of 2k characters, I searched and found the following relevant to Access 2010:
>
> https://support.office.com/en-za/article/Access-2010-specifications-1e521481-7f9a-46f7-8ed9-ea9dff1fa854
>
> "Number of characters in an SQL statement  Approximately 64,000*
>   
> *Maximum values might be lower if the query includes multivalued lookup fields."
>
> Earlier versions may have had lower limits, but let's hope that 2010 and beyond are at least as much as this.
>
> This particular spec relates to Query objects.  Does anybody know if a similar limit exists for SQL that's built and executed in code?  Just wondering if there may be a difference.
>
>
>



More information about the AccessD mailing list