This is a continuation of http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27816078.html
In that question, one of the Experts gave me some SQL for an UPSERT query - a combination of UPDATE and INSERT. At this point, I noticed that sometimes it doesn't work, so I wanted to verify the syntax and make sure that I have it right.
Here's my SQL - can anyone help?
UPDATE MSysObjects LEFT JOIN ExportObjExportedT
ON MSysObjects.Name = ExportObjExportedT.ObjectName
SET ExportObjExportedT.ObjectName = [MSysObjects].[Name],
ExportObjExportedT.LastExported = now()
WHERE objectname = 'LogOutF';