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