Jumat, 12 Februari 2016

[MS_AccessPros] pdateable query with SQL linked tables


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"

Please help.



Posted by: runuphillracing@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)



Tidak ada komentar:

Posting Komentar