[AccessD] update query using values from a query

Susan Harkins ssharkins at bellsouth.net
Wed Jun 2 19:16:15 CDT 2004


??? Jim -- I don't understand the request. 

Susan H. 

Hi Susan:

Show me the query...

Jim



I am trying to do an update query updating a table with the values from a
query. I get the message that "Operation must use an updateable query"  so
it won't run. But I am not trying to update the query! I'm just wanting to
use the values from the query to update the table.

==========That error means you can't use the query to update the underlying
table. Not every query is "updateable." There are rules and I'll send you
something privately. 

Susan H. 

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




More information about the AccessD mailing list