Union Query - Specification Limits

[Guest]

I have a union query which runs 18 different append queries (from 9 different db's). This works fine.

The 9 databases are 9 different countries. I now need to add a new Country (10th db = 2 more queries) and I get the following error "The text is too long to be edited" when I try to add the 2 new sql statements in the current Union Query.

The 2 Append queries on their own run fine and append records like the others.

Is there a limit in the lenght of the text of a Union Query?

Thanks in advance.

 

[Petrucci2000]

Hi,

My name is Eric. Thank you for using the Microsoft Access Newsgroups.

You wrote:
"Is there a limit in the lenght of the text of a Union Query?"

Microsoft Access help topic "Specification"
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 gigabyte
Number of levels of nested queries 50
Number of characters in a cell in the query design grid 1,024
Number of characters for a parameter in a parameter query 255
Number of ANDs in a WHERE or HAVING clause 99
Number of characters in an SQL statement approximately 64,000


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."