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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max length of variable name? 7
Build SQL statement 2
sql queries 2
Maximun size of a database 6
Keeping Access Running Between SQL Server Reboots 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
Emulate XOR in Access 5
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top