[AccessD] Problem with an update query

Gustav yview is a static local table.
On Aug 4, 2012 3:41 AM, "Gustav Brock" <gustav at cactus.dk> wrote:

> Hi William
>
> > .. the only linked tables in the below query is YVIEW.
> > I am not updating a linked table!
>
> Well, that may be what you think. However, you state:
>
> SET
> YVIEW.DOM_CUSTOMER_NAME = [DOM].[CUSTOMER_NAME];
>
> Besides, if this is a linked Excel table, that could also explain the
> error message.
>
> /gustav
>
>
> -----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
>