Can you update information in a Union Query

  • Thread starter Thread starter Mark Carlyle via AccessMonster.com
  • Start date Start date
M

Mark Carlyle via AccessMonster.com

If I make a SQL Union Query to combine multiple databases for lookup
purposes, can I edit the information and have it update the origionating
table?
 
Mark said:
If I make a SQL Union Query to combine multiple databases for lookup
purposes, can I edit the information and have it update the origionating
table?
Click to expand...

No. The db engine would not "know" which table to update.
 
A union query is not updateable so you can not edit the information in a
form based on the union query. However, you can create separate queries for
the tables included in the union query snd base forms on these queries to
edit the information in the tables.
 
If I make a SQL Union Query to combine multiple databases for lookup
purposes, can I edit the information and have it update the origionating
table?
Click to expand...

No.

Simple as that. A UNION query is not and cannot be made updateable.

John W. Vinson[MVP]
 
Back
Top