By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,763 Members | 1,667 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,763 IT Pros & Developers. It's quick & easy.

Union query updatable or not

P: n/a
Hi,
Here is my code for the Union query "Table [Mytable1]
union Table [Mytable2] union Table [Mytable3];"
The tables are actually queries themselves.
I made a form for the query, but when I try to update the form, I get a
message that says "This recordset is not updatable." Can I somehow make it
updatable?

Thanks
P.S. Using access 2000.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Enterprise wrote:
Hi,
Here is my code for the Union query "Table [Mytable1]
union Table [Mytable2] union Table [Mytable3];"
The tables are actually queries themselves.
I made a form for the query, but when I try to update the form, I get a
message that says "This recordset is not updatable." Can I somehow make it
updatable?


Er, no. Imagine you're the database engine and get a new record. How do
you know which table to put it in?

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

P: n/a
On Thu, 25 Nov 2004 20:26:19 GMT, "Enterprise" <so*****@microsoft.com>
wrote:

No. Union queries are never updatable.
Next best thing may be to update yourself, which means you need to
know which table a particular record came from. This is a handy way to
do that:
select "table1" as TableFrom, * from table1
union
select "table2" as TableFrom, * from table2

-Tom.

Hi,
Here is my code for the Union query "Table [Mytable1]
union Table [Mytable2] union Table [Mytable3];"
The tables are actually queries themselves.
I made a form for the query, but when I try to update the form, I get a
message that says "This recordset is not updatable." Can I somehow make it
updatable?

Thanks
P.S. Using access 2000.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.