How long can be SQL-Query (how meny characters maximally)?

  • Thread starter Thread starter Mario Krsnic
  • Start date Start date
M

Mario Krsnic

Hello!
How long can be SQL-Query (how meny characters maximally)?
Is it same for all sorts of queries. For instance db.Execute??
Thanks
Mario
 
Hi, Mario.
How long can be SQL-Query (how meny characters maximally)?
Click to expand...

Approximately 64,000 characters when using Jet 4.0.
Is it same for all sorts of queries. For instance db.Execute??
Click to expand...

Yes. However, there are other restrictions that can apply when using
different approaches to building queries. For example, when using the QBE
query design grid, a maximum of 1,024 characters can be placed in a single
cell of the query design grid. See the Online Help Topic "Specifications"
for more information.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
 

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

Update query issue 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Remove menus in a maximized mdi child form 1
Query design view - commas being changed to pipe characters 4
Query Key 3
Use first 3 characters in query 4
Characters found at end of sql error 1
SQL string longer than 255 characters 4

Back
Top