I searched quite a bit and went through the normal answers of securities and permissions. I still cannot make this query work. It's simple and was working one day, and then a few days ago it broke. Nothing significant has changed since then. I have tried recreating the query from scratch (all on field of it), but still to no avail.
Any thoughts?
Code:UPDATE tbl_ERC_Cases INNER JOIN dbo_INV ON tbl_ERC_Cases.InvestorCode = dbo_INV.INV SET tbl_ERC_Cases.InvestorName = dbo_INV!INVESTOR;