Maximum Length of a SQL Query in Microsoft Access 2010?

sql ms-access ms-access-2010 pass-through
iokevins picture iokevins · Oct 8, 2011 · Viewed 12.5k times · Source

Attempting to copy/paste a 159KB TSQL query into Microsoft Access 2010 passthrough query editor (to a Microsoft SQL Server 2008 backend).

This produces pop-up error, "The text is too long to be edited".

What is the maximum length of a query in Microsoft Access 2010?

Answer

Dzoki picture Dzoki · Oct 8, 2011

The help file says that the maximum number of characters in a SQL statement is approximately 64,000. It doesn't mention any difference between pass through queries and other queries, so in the absence of any specific documentation I'm assuming that this also applies to pass through queries.

Related questions

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am stuck as it is throwing an error: Too few parameters. I have a table test with only one column in …

Read More
How do you trouble shoot a "Data type mismatch in criteria expression" error in MS Access 2010?

I am trying to troubleshoot a Report in an MS Access Database. This file was build by the person that held my role before I joined the organization I work for. The report is throwing an error "Data type mismatch …

Read More
CONCAT equivalent in MS Access

I'm doing some work in MS Access and I need to append a prefix to a bunch of fields, I know SQL but it doesn't quite seem to work the same in Access Basically I need this translated to a …

Read More