[AccessD] Problem with an update query

Stuart McLachlan stuart at lexacorp.com.pg
Sat Aug 4 02:38:32 CDT 2012


What sort of database is the table YVIEW in. How are you linking to it (ODBC? What is the 
driver?)

-- 
Stuart 

On 4 Aug 2012 at 3:29, William Benson (VBACreations. wrote:

> No one??
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William
> (GE Global Research, consultant)
> Sent: Thursday, August 02, 2012 11:29 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Problem with an update query
> 
> I am getting a message "You won't be able to undo the changes this action
> query is about to make to the data in a linked table or tables. Do you want
> to run the query anyway?"
> 
> However, the only linked tables in the below query is YVIEW. I am not
> updating a linked table!
> 
> So then I click OK to run the query and get a message "Updating the data in
> a linked table is not supported by this ISAM"
> 
> How can I get past this?
> 
> UPDATE (YVIEW 
> 	LEFT JOIN TblCMF AS Cust1 ON 
> 		YVIEW.SITE_DUNS_NO = Cust1.DUNS_NUMBER) 
> 	LEFT JOIN TblCMF AS DOM ON 
> 		Cust1.MAS_DOM_ULT_DUNS = DOM.DUNS_NUMBER SET
> YVIEW.DOM_CUSTOMER_NAME = [DOM].[CUSTOMER_NAME];
> 
> 
> 
> -- 
> 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