MDB SQL Acees Query exceeding 1024 characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I am trying to write a union query that is greater than 1024 characters in
MS Acess 2003.

Is there a way around this restriction without having to create mutiple
queries?

Thanks
Vineet
 
Are you sure about the limit?

Even in A2000 and A2002, the length limit of the SQL String is 64K
characters AKAIK.

Check Access Help topic "Microsoft Access specifications".

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

Pipe character in query in VB6 app 11
sql string length 2
Make Table Query in NEW ACCESS file 1
Build SQL statement longer than 1024 4
query links to SQL server and mdb table 1
UNION Truncates Memo Fields 2
Unexplained MakeTable SQL addition 4
Currency Format Lost in Union Query 1

Back
Top