Jumat, 12 Februari 2016

[MS_AccessPros] Re: pdateable query with SQL linked tables

 

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: runuphillracing@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar