Hi, Mario.
How long can be SQL-Query (how meny characters maximally)?
Approximately 64,000 characters when using Jet 4.0.
Is it same for all sorts of queries. For instance db.Execute??
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
[email protected] and
[email protected]
