[AccessD] Can't Alter Values in a Query with Subquery

Charlotte Foust cfoust at infostatsystems.com
Wed Feb 28 10:08:12 CST 2007


You've done something to make the query non-updateable, Susan.  You'll
have to post the SQL before anyone can figure it out.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Wednesday, February 28, 2007 7:48 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Can't Alter Values in a Query with Subquery

I've found that I can't alter values in a query with a subquery -- can't
alter any value in the query -- even values not evaluated in the
subquery.
I'm sure there's a reason why, just curious -- never noticed this
before. 

Susan H. 

--
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