[AccessD] Operation must use an updateable query

William Hindman wdhindman at bellsouth.net
Wed Feb 26 10:59:59 CST 2003


...look under "update data from a query" in your help file ...lots of
gotchas and work arounds.
William Hindman

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


> It seems to me that the query pulling the ID of the records to be updated
> could be inserted as a sequel statement into an IN clause?
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of William Hindman
> Sent: Wednesday, February 26, 2003 11:06 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [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
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.
> Try it free!  http://www.eMailBoss.com
>





More information about the AccessD mailing list