Maximun length of a SQL stament in Access?

  • Thread starter Thread starter Cristina Lopez
  • Start date Start date
C

Cristina Lopez

Please, tell me the size of the largest sql statement that can be created
for Access.
Thanks
 
64K characters for the SQL String. There are some more
limits if you use the Query Grid.

Check Access Help on "specifications" for other limits.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top