[AccessD] Operation must use an updateable query

Arthur Fuller artful at rogers.com
Thu Feb 27 09:05:19 CST 2003


Does your SQL fail in QA as well, or just in Access? You may be able to
sidestep the problem by creating a view first that retrieves the claims of
interest, then join that to the claims table, then change the query into an
update query.

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby
Sent: February 26, 2003 10:20 AM
To: AccessD
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




More information about the AccessD mailing list