ADD FIELDS TO TABLES USING QUERY??

  • Thread starter Thread starter BRENNON
  • Start date Start date
B

BRENNON

My database houses many tables which contain similar
information (identical fields). Is there a way to add a
new field to each of these tables using any type of
query? I am trying to avoid having to add the same field
to each table if possible.
 
My database houses many tables which contain similar
information (identical fields).
Click to expand...

Then it is an incorrectly normalized database. This design is a
CERTAIN recipe for trouble!

A better structure would be to have *ONE* big table, with an
additional (indexed) field identifying what's now the table name. You
can easily create Queries to extract just one "table"'s data, and you
can much more easily search across "Tables".
Is there a way to add a
new field to each of these tables using any type of
query? I am trying to avoid having to add the same field
to each table if possible.
Click to expand...

You'ld have to write (or revise) as many ALTER TABLE queries as there
are tables to edit, or write VBA code to loop through the Tabledefs
collection and alter each table.
 
Back
Top