469,927 Members | 1,902 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Union query updatable or not

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
2 2316
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
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.

Similar topics

3 posts views Thread by Paradigm | last post: by
4 posts views Thread by John Baker | last post: by
reply views Thread by Mario Zoratti | last post: by
2 posts views Thread by GD | last post: by
4 posts views Thread by spam | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.