Jumat, 12 Februari 2016

Re: [MS_AccessPros] Re: pdateable query with SQL linked tables


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

On Feb 12, 2016, at 21:23, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Duane, sorry.

Crystal, what?



---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:

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.



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