Union queries..max # of fields?

[GSMike]

I am trying to create a union query and getting an error message:
"Too many fields defined."
Anybody know the maximum number of fields allowed in a union query? I can't find anything in the documentation on it.
Thanks for your help.
Mike Kemp

 

[timgill]

I found this in the MSDN Library Docs:

The Microsoft Jet database engine has an internal limit of 255 fields per query.

And then this (which might count for Union Queries as well):
As the Microsoft Jet database engine iterates through the records in an update query, it creates a field for the original value and a field for the updated value. When more than 127 fields are selected, it reaches the 255 field limit of a query.

Tim Gill
Gill Consulting

http://www.dagills.com