Maximun length of a SQL stament in Access?

C

Cristina Lopez

Please, tell me the size of the largest sql statement that can be created
for Access.
Thanks
 
V

Van T. Dinh

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)
 
Top