[AccessD] Operation must use an updatable query

Gustav Brock Gustav at cactus.dk
Thu Jun 9 10:28:24 CDT 2011


Hi Ken

So true ... don't know why some are so afraid of temp tables. They provide a clean and verifiable cut between what to update and the actual update.
William, if bloat is a concern, move the temp tables to a temp database.

/gustav


>>> kismert at gmail.com 09-06-2011 17:09 >>>
>
> William Benson
> ...
> I know others have solved this with temp tables but I do not want to bloat
> the database
> ...
>

Bloat on -- temp tables are the only reliable solution for this classic
Access annoyance.

I personally do not trust many-to-one updates -- they have failed too often
for me.

BTW, in this case the problem is not with the subquery, or the number of
joins -- summary queries (GROUP BY) are inherently non-updatable.

You can easily insert using a summary query, but you can't update using one
as your data source in Access, even when the target is perfectly updatable.

A really stupid limitation.

-Ken





More information about the AccessD mailing list