[AccessD] Operation must use an updatable query

Kenneth Ismert kismert at gmail.com
Thu Jun 9 10:09:26 CDT 2011


>
> 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