MS Access 2013 Update Query Syntax Error - SharePoint Linked list update Access table

[Corinne]

Hello:

I'm using MS Access 2013 & SharePoint 2010. I’m trying to create a table in Access by linking to an existing SharePoint list. I want them to be linked, so that I’m capturing any data changes made and/or new records in the SharePoint list. However, I do not want changes that I make in the MS Access table to be reflected in the SharePoint list.

The trouble is that I'm getting a "syntax error (missing operator) in query expression 'src.Modified > des.Modified". I'm not experienced in MS Access...everything I'm doing, I've learned by web search. Presently, I'm stuck with how to proceed efficiently. Any help would be appreciated!

I've copied the SharePoint list and saved as an MS Access table. Then I created an update query as follows:

UPDATE MSAccessTbl AS des INNER JOIN LinkedSharePointList AS src SET
des.Field1 = src.Field1, des.Field2 = src.Field2
WHERE src.Modified > des.Modified

Then:
INSERT INTO MSAccessTbl
(Field1, Field2)
SELECT src.Field1, src.Field2
FROM LinkedSharePointList AS src
LEFT JOIN MSAccessTbl AS des
WHERE des.ID IS NULL;