How can I delete using INNER JOIN with SQL Server?

SQL Query works in SQL Server but not in VB.NET with ACCDB

Smith

This SQL Query works in SQL Server but not in Microsoft Access or VB.NET

There are 2 Tables

Table 1 (Name, IdNum, Id2) Table 2 (Col1, Col2, Col3, IdNum, Id2)

UPDATE Tabla1 SET Name = CONCAT_WS(' ',Tabla2.Col1,Tabla2.Col2,Tabla2.Col3) from Tabla2 join Tabla1 on Tabla1.IdNum = Tabla2.IdNum and Tabla1.Id2 = Tabla2.Id2

In SQL Server Works Fine, in Access and VB.NET it doesn't work.