Enhance Union-Query architecture that total field count more over 255
Please re-design that a Union query of MS Access deal with more over 255 source fields totaly like 1024 or 65535 fields.
Patrick Honorez commented
Since this amount is over the number of fields allowed in an Access table, I suppose you want to use this with Oracle or SQl Server. In that case, you can use a passthru query, which will let you overcome that limit.
I've never come remotely close to even 255. As already noted ... please give a real life example.
Could you give a real-life scenario when you need more than 255 fields? I find this very odd and would love to understand the request.