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.


Adam



__._,_.___

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