Max size of SQL String

  • Thread starter Thread starter vt
  • Start date Start date
V

vt

What is the maximum size of an MS-access SQL Query String?
I am trying to execute a insert query with about 6500
length SQL string from VB using dao. It throws a error
regarding conversion from character string to
uniqueidentifier.
Any inputs would be helpful.
 
I can't find an explicit limit, however this does seem an excessive bit of
SQL.

To try and solve it, what if you cut and paste the SQL into a query using
Access?
 
Back
Top