Update query- update a copy of entire table

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

I made a copy of a large table that has many fields. Is
there a quick way to write an update query so that all
the corresponding fields will get updated (without my
having to go through and specify field by field)?
 
I made a copy of a large table that has many fields. Is
there a quick way to write an update query so that all
the corresponding fields will get updated (without my
having to go through and specify field by field)?
Click to expand...

not that I know of. Why would you WANT to do this though!? Storing the
same data in two separate tables is redundant, hard to manage, and can
be a real pain in the neck. Can you instead use File... Get External
Data... Link to link to the "real" table, so that another user can see
the data? If you provide them with a Form and set its AllowEdits
property to False they'll be able to see the data (in real time, up to
the minute) but not change it.
 
Back
Top