[AccessD] Operation must use an updateable query

JC

...sounds like you are using a query based on tables with a m2m relationship
...which would make the query non-updateable ...this usually requires either
rewriting the query or writing code to do the updates you want ...lots of
sample code in the Help and KB re this ...HTH :)

William Hindman

----- Original Message -----
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD" <AccessD at databaseadvisors.com>
Sent: Wednesday, February 26, 2003 10:19 AM
Subject: [AccessD] Operation must use an updateable query


> I have a database where a claim table has an event child table.  The event
> table may have an event such as Open for a set of claims.  In order to
> discover which claims have an open event I have a query that pulls out
that
> event and has the claim id exposed.  now I want to update a field in every
> claim that has an open event (as an example).  Trying to do so generates
the
> infamous "Operation must use an updateable query".  this is one I have
> banged into before and never really understood why I get it, not how to
> reliably not get it.
>
> Update a field in the parent table, if it has a related record in the
child
> table.  It sounds so simple.  How is it done?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.
> Try it free!  http://www.eMailBoss.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>