The following query worked when the linked BE was in Access. After moving to SQL, I get a Run-time error 3073, must use updateable query.
stSQL = "UPDATE tblUpdateFE, tblUpdateBE " & _
"SET tblUpdateFE.UpdateParent = tblUpdateBE.UpdateParent"
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|