[AccessD] Updatable UNION?

Unions are not updatable by definition, Susan, no matter what tricks you
use.  In a Union, there is no distinction between the tables the fields
come from and the names don't even have to match,just the datatypes, so
there's no way to update any of the data.

Charlotte Foust


-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Friday, November 19, 2004 6:13 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Updatable UNION?


There is some odd trick in the back of my mind that I just can't quite
remember... 

Is there some trick about adding ALL to a UNION that makes it
updateable? I know, I'm probably crackers -- and I'm probably confusing
this with something else. 

All of my books are in storage and I can't even try to look it up. :( 

Susan H. 

Andy,

This might sound like dancing around this issue...but could you have
user click on the record to be updated...open a second query/form for
just that record...save the record...and the give a message, "Your
update has been saved and will be reflected next time you refresh the
screen".


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com