Ah, I didn't notice you had FE and BE. What is the Primary Key of the two tables? Do a Join on that, then the update should run.
John Viescas
Sent from my iPad
Sent from my iPad
On Feb 12, 2016, at 21:23, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Duane, sorry.
Crystal, what?
Thanks
Adam
---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :
it makes sense if you want to impose an input mask with symbols
On 2/12/2016 9:36 AM, John Viescas JohnV@... [MS_Access_Professionals] wrote:
Adam-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.John Viescas
Sent from my iPad
On Feb 12, 2016, at 17:21, runuphillracing@... [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"
Please help.
Adam
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar