Gary Kjos
garykjos at gmail.com
Wed Feb 28 10:50:24 CST 2007
I would write the results of the non-updateable query out to a temp file and then join that temp table to the table I want to update and do my update. It's an extra step but for the largely one time stuff I do it's not that bad. Keeps me from beating my head against it insisting it SHOULD BE ABLE TO update in the other one. But if Access says it's not updatable it's no use arguing with it. It's not listening to my arguements to the contrary. GK On 2/28/07, Susan Harkins <ssharkins at setel.com> wrote: > Yelp... calculated field. You know, I've written about this at least three > times, and I can't even remember it myself. :( > > Interestingly, a query based on the non-updateable query is also > non-updateable. Don't really know a way around that. What do you guys do? > > Susan H. > > http://msdn2.microsoft.com/en-us/library/aa198446(office.10).aspx > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com