I am using VB4 with DAO 3.0 and a MS Access database version 7.
I am trying to update a table T1 with the following query:

Dim SQL As String
SQL = "UPDATE T1 INNER JOIN T2 ON T1.ID=T2.ID SET T1.Name = T2.Name"
Call DB.Execute(SQL, dbFailOnError)

with T1 containing a foreign key ID that references T2.ID.

The query executes withou an error and even reports the correct number of
records affected but the records remain unchanged.
If I execute the same query within Access it works.

Does anyone have an idea ?