A
alex
Hello everyone,
Using Access ’03…
I’ve searched the archives of this group but have not found a specific
answer to the question below:
I have a dozen or so tables, populated by as many people. The tables
are not that big (only a few rows), albeit a bit wide (30 or so
columns).
The tables are used in an ODBC connection with ORACLE. I need to
combine them into one table in Access. I’ve tried using a union
query, which I’ve used before in other applications. I get the error
too many fields defined! I know what that means, but I can’t
understand why I cannot combine 15 tables into one, especially when
the combined table will only possess 30 columns and about a hundred
rows. Where does Access derive 255 from this? Is it multiplying 15 *
30?
Any thoughts?
Thanks,
alex
Using Access ’03…
I’ve searched the archives of this group but have not found a specific
answer to the question below:
I have a dozen or so tables, populated by as many people. The tables
are not that big (only a few rows), albeit a bit wide (30 or so
columns).
The tables are used in an ODBC connection with ORACLE. I need to
combine them into one table in Access. I’ve tried using a union
query, which I’ve used before in other applications. I get the error
too many fields defined! I know what that means, but I can’t
understand why I cannot combine 15 tables into one, especially when
the combined table will only possess 30 columns and about a hundred
rows. Where does Access derive 255 from this? Is it multiplying 15 *
30?
Any thoughts?
Thanks,
alex