[AccessD] Operation must use an updatable query

Put the temp tables in a temp db or use the compact on close option.

Jim

Sent from my iPhone

On Jun 9, 2011, at 11:09 AM, Kenneth Ismert <kismert at gmail.com> wrote:

>> 
>> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com