it makes sense if you want to impose an input mask with symbols
Get rid of the second reference to tblUpdateBE after the UPDATE keyword.
But why are you setting a field equal to itself? That makes no sense.
Sent from my iPad
On Feb 12, 2016, at 17:21, firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: crystal 8 <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|