Roberto F. Long
rford at terra.com.br
Sat Aug 4 16:00:59 CDT 2012
Just a long shot... I had a lot of this issues converting data from Dataflex / Paradox files to Access long time ago. It was because a linked table don't have a PK, or if it had a valid PK it was not assigned when it was linked, or in my case the Dataflex / Paradox ODBC drivers that I used don't have a update on-line index. And don't matter if I created a RO view, always same message. So I imported that tables to Access, defined valid PK and it worked. It was used only to data / system conversion from Dataflex to Access. It was used just for data conversion. Regards, Roberto. -----Mensagem original----- De: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Em nome de William Benson (VBACreations.Com) Enviada em: sábado, 4 de agosto de 2012 04:30 Para: 'Access Developers discussion and problem solving' Assunto: Re: [AccessD] Problem with an update query 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