Ci riprovo. Ho semplificato la query sperando che qualcuno possa darmi una mano. E' una query che ado lancia su un DB Access.
In Access funziona, mentre in visual basic mi genera l'errore di run–time –2147217900 (80040e14)
Join expression not supported.


N = “DELETE TSNOTES.* “ _
& “FROM ((TSNOTES LEFT JOIN (TS “ _
& “LEFT JOIN ((ASSN “ _
& “LEFT JOIN PJ ON ASSN.pjID = PJ.pjID) “ _
& “LEFT JOIN TASK ON ASSN.taskID = TASK.taskID) ON TS.tsWAID = “ & _
“ASSN.assnID) ON TSNOTES.tsID = TS.tsID) “ _
& “LEFT JOIN WACOMM ON TS.tsWAID = WACOMM.wacommID) “ _
& “LEFT JOIN ABSN ON TS.tsWAID = ABSN.absnID;"