Limit to UNION queries in Access 2003?

[thendrickson]

Does anyone know if there is an upper limit to the number of UNIONs you can use in an Access query (Access 2003)?

 

[Golom]

I seem to vaguely recall 50 as being the limit.

 

[thendrickson]

Thanks

 

[dhookom]

I have hit a smaller limit which I think might depend somewhat on the number of columns in the union query.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

There is also a 32 table limit per query. Not sure how that plays out in a union query.

 

[dhookom]

I have also heard the 255 field limit applies. This would cause a limit at about 25 tables each with 10 fields.

Duane
Hook'D on Access
MS Access MVP

 

[thendrickson]

Thanks to everyone.
None of these ideas quite fit.
However, it is a moot point.
Once I researched further with the client, I discovered that a previous developer did not import data into a new mormalized table properly. Once I determined that correcting this would not break anything else, I simply completed his task, and no longer needed the UNION query.
I appreciate the effort