The Access database shows linked table to SQL Server (tblWork) and maintains local copies (tblWork_Local)
Before I upgraded to this configuration from a simple Access database, this update query worked
UPDATE tblWork
INNER JOIN tblWrkWkAllDates
ON tblWork.BDT = tblWrkWkAllDates.WDate...
