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