Hi all,
I created an update query that is designed to update the data in a linked SharePoint. I have created the query fine but when I try to execute the update query I get an error stating:
'qryAMYPOCUpdater' is not a valid name. Make sure that it does not include invalid characters or punctuation blah blah blah
The SQL for the query is posted below. The strange part is I can view this query in datasheet view without a problem, but when I try and execute the query the issue appears. Im wondering if its anything to do with the field names in the linked SharePoint list (see the SQL for details). I cannot change the SharePoint list names as I dont have the permissions to do so. If anyone can shed some light on this issue that would really be appreciated. This is the first time I have come across this issue in 10 years of using Access.
If it helps, I am using Access 2007. The access dbase resides in my usual dev databases directory on my server and I have plenty of other Access applications in there that run update queries without an issue, so I know its not a path problem.
SQL:
UPDATE qryPOCMMTLogUpdater INNER JOIN [POC MMT Log] ON qryPOCMMTLogUpdater.ID = [POC MMT Log].ID SET [POC MMT Log].MMT = [qryPOCMMTLogUpdater].[MMT], [POC MMT Log].Supplier = [qryPOCMMTLogUpdater].[Supplier], [POC MMT Log].[Date MMT Sent] = [qryPOCMMTLogUpdater].[Date MMT Sent], [POC MMT Log].[Material Description] = [qryPOCMMTLogUpdater].[Material Description], [POC MMT Log].[Commercial Invoice Value] = [qryPOCMMTLogUpdater].[Commercial Invoice Value], [POC MMT Log].[Currency] = [qryPOCMMTLogUpdater].[Currency], [POC MMT Log].[Shipment Value (AUD)] = [qryPOCMMTLogUpdater].[Shipment Value (AUD)], [POC MMT Log].[Package Qty] = [qryPOCMMTLogUpdater].[Package Qty], [POC MMT Log].[Total CBM] = [qryPOCMMTLogUpdater].[Total CBM], [POC MMT Log].[Gross Weight (kgs)] = [qryPOCMMTLogUpdater].[Gross Weight (kgs)], [POC MMT Log].FRT = [qryPOCMMTLogUpdater].[FRT], [POC MMT Log].TEU = [qryPOCMMTLogUpdater].[TEU], [POC MMT Log].FEU = [qryPOCMMTLogUpdater].[FEU], [POC MMT Log].[DBS Operator] = [qryPOCMMTLogUpdater].[DBS Operator], [POC MMT Log].[Planning Number] = [qryPOCMMTLogUpdater].[Planning Number], [POC MMT Log].SCN = [qryPOCMMTLogUpdater].[SCN], [POC MMT Log].MOT = [qryPOCMMTLogUpdater].[MOT], [POC MMT Log].[MOT Type] = [qryPOCMMTLogUpdater].[MOT Type], [POC MMT Log].[Flight / Vessel Name] = [qryPOCMMTLogUpdater].[Flight / Vessel Name], [POC MMT Log].[Waybill No#] = [qryPOCMMTLogUpdater].[Waybill No.], [POC MMT Log].[Origin Country] = [qryPOCMMTLogUpdater].[Origin Country], [POC MMT Log].[Origin Port] = [qryPOCMMTLogUpdater].[Origin Port], [POC MMT Log].[Destination Port] = [qryPOCMMTLogUpdater].[Destination Port], [POC MMT Log].Consignee = [qryPOCMMTLogUpdater].[Consignee], [POC MMT Log].Collected = [qryPOCMMTLogUpdater].[Collected], [POC MMT Log].ETD = [qryPOCMMTLogUpdater].[ETD], [POC MMT Log].ATD = [qryPOCMMTLogUpdater].[ATD], [POC MMT Log].ETA = [qryPOCMMTLogUpdater].[ETA], [POC MMT Log].Delivered = [qryPOCMMTLogUpdater].[Delivered], [POC MMT Log].[KJV Referral] = [qryPOCMMTLogUpdater].[KJV Referral], [POC MMT Log].Remarks = [qryPOCMMTLogUpdater].[Remarks], [POC MMT Log].[ProCarS File Number] = [qryPOCMMTLogUpdater].[ProCarS File Number], [POC MMT Log].[Delivered / Transit / Planning] = [qryPOCMMTLogUpdater].[Delivered / Transit / Planning], [POC MMT Log].[Open / Closed] = [qryPOCMMTLogUpdater].[Open / Closed], [POC MMT Log].[Purchased / Upstream] = [qryPOCMMTLogUpdater].[Purchased / Upstream], [POC MMT Log].ATA = [qryPOCMMTLogUpdater].[ATA], [POC MMT Log].[Vessel ID] = [qryPOCMMTLogUpdater].[Vessel ID], [POC MMT Log].[AU Destination] = [qryPOCMMTLogUpdater].[EDR (AU Dest.)], [POC MMT Log].[Calculated EDR (AU Dest#)] = [qryPOCMMTLogUpdater].[Calculated EDR (AU Dest.)], [POC MMT Log].[EDR (AU Dest#)] = [qryPOCMMTLogUpdater].[EDR (AU Dest.)];
I created an update query that is designed to update the data in a linked SharePoint. I have created the query fine but when I try to execute the update query I get an error stating:
'qryAMYPOCUpdater' is not a valid name. Make sure that it does not include invalid characters or punctuation blah blah blah
The SQL for the query is posted below. The strange part is I can view this query in datasheet view without a problem, but when I try and execute the query the issue appears. Im wondering if its anything to do with the field names in the linked SharePoint list (see the SQL for details). I cannot change the SharePoint list names as I dont have the permissions to do so. If anyone can shed some light on this issue that would really be appreciated. This is the first time I have come across this issue in 10 years of using Access.
If it helps, I am using Access 2007. The access dbase resides in my usual dev databases directory on my server and I have plenty of other Access applications in there that run update queries without an issue, so I know its not a path problem.
SQL:
UPDATE qryPOCMMTLogUpdater INNER JOIN [POC MMT Log] ON qryPOCMMTLogUpdater.ID = [POC MMT Log].ID SET [POC MMT Log].MMT = [qryPOCMMTLogUpdater].[MMT], [POC MMT Log].Supplier = [qryPOCMMTLogUpdater].[Supplier], [POC MMT Log].[Date MMT Sent] = [qryPOCMMTLogUpdater].[Date MMT Sent], [POC MMT Log].[Material Description] = [qryPOCMMTLogUpdater].[Material Description], [POC MMT Log].[Commercial Invoice Value] = [qryPOCMMTLogUpdater].[Commercial Invoice Value], [POC MMT Log].[Currency] = [qryPOCMMTLogUpdater].[Currency], [POC MMT Log].[Shipment Value (AUD)] = [qryPOCMMTLogUpdater].[Shipment Value (AUD)], [POC MMT Log].[Package Qty] = [qryPOCMMTLogUpdater].[Package Qty], [POC MMT Log].[Total CBM] = [qryPOCMMTLogUpdater].[Total CBM], [POC MMT Log].[Gross Weight (kgs)] = [qryPOCMMTLogUpdater].[Gross Weight (kgs)], [POC MMT Log].FRT = [qryPOCMMTLogUpdater].[FRT], [POC MMT Log].TEU = [qryPOCMMTLogUpdater].[TEU], [POC MMT Log].FEU = [qryPOCMMTLogUpdater].[FEU], [POC MMT Log].[DBS Operator] = [qryPOCMMTLogUpdater].[DBS Operator], [POC MMT Log].[Planning Number] = [qryPOCMMTLogUpdater].[Planning Number], [POC MMT Log].SCN = [qryPOCMMTLogUpdater].[SCN], [POC MMT Log].MOT = [qryPOCMMTLogUpdater].[MOT], [POC MMT Log].[MOT Type] = [qryPOCMMTLogUpdater].[MOT Type], [POC MMT Log].[Flight / Vessel Name] = [qryPOCMMTLogUpdater].[Flight / Vessel Name], [POC MMT Log].[Waybill No#] = [qryPOCMMTLogUpdater].[Waybill No.], [POC MMT Log].[Origin Country] = [qryPOCMMTLogUpdater].[Origin Country], [POC MMT Log].[Origin Port] = [qryPOCMMTLogUpdater].[Origin Port], [POC MMT Log].[Destination Port] = [qryPOCMMTLogUpdater].[Destination Port], [POC MMT Log].Consignee = [qryPOCMMTLogUpdater].[Consignee], [POC MMT Log].Collected = [qryPOCMMTLogUpdater].[Collected], [POC MMT Log].ETD = [qryPOCMMTLogUpdater].[ETD], [POC MMT Log].ATD = [qryPOCMMTLogUpdater].[ATD], [POC MMT Log].ETA = [qryPOCMMTLogUpdater].[ETA], [POC MMT Log].Delivered = [qryPOCMMTLogUpdater].[Delivered], [POC MMT Log].[KJV Referral] = [qryPOCMMTLogUpdater].[KJV Referral], [POC MMT Log].Remarks = [qryPOCMMTLogUpdater].[Remarks], [POC MMT Log].[ProCarS File Number] = [qryPOCMMTLogUpdater].[ProCarS File Number], [POC MMT Log].[Delivered / Transit / Planning] = [qryPOCMMTLogUpdater].[Delivered / Transit / Planning], [POC MMT Log].[Open / Closed] = [qryPOCMMTLogUpdater].[Open / Closed], [POC MMT Log].[Purchased / Upstream] = [qryPOCMMTLogUpdater].[Purchased / Upstream], [POC MMT Log].ATA = [qryPOCMMTLogUpdater].[ATA], [POC MMT Log].[Vessel ID] = [qryPOCMMTLogUpdater].[Vessel ID], [POC MMT Log].[AU Destination] = [qryPOCMMTLogUpdater].[EDR (AU Dest.)], [POC MMT Log].[Calculated EDR (AU Dest#)] = [qryPOCMMTLogUpdater].[Calculated EDR (AU Dest.)], [POC MMT Log].[EDR (AU Dest#)] = [qryPOCMMTLogUpdater].[EDR (AU Dest.)];
Last edited: