upper limit on SQL query size

I am working on an application that requires a number of SQL queries to be joined with UNION ALL statements.

Is there an upper limit as to how many can be joined in SQL? Or in MS Access?

On my computer Access cannot process more than about 20 queries joined together. I would like to know if this is an Access restriction, an SQL one, or just my computer. Received on Sat Jul 14 2001 - 16:32:35 CDT