Union of 3 Access Tables - Error: "Too Many Fields Defined."?
Posted on 2004-10-07
I have 3 Access tables with 182 fields and 150,000 records each. All 3 tables share the same 182 fields.
When I try to Union them, I get an error: "Too Many Fields Defined".
I'm confused because they are the same 182 fields, why "Too Many Fields Defined"? I didn't define any new fields!
It seems like there is a memory issue but isn't the error msg misleading or am I missing something?
My goal is to get the average of all 450,000 records by 18 predefined catergories.
Am I out of luck?