Jumat, 12 Februari 2016

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

 

    

John,


There isn't, or wasn't. Is that something necessary with SQL, but not Access linked tables? This is for future reference.


I'm changing this particular structure from horizontal (diff date/time field for ea type of table) to vertical. I'm scrolling through the tables list as a recordset, comparing the UpdDate fields, updating the FE tables as needed via

"DROP TABLE" and

"SELECT " & stTblBE & ".* INTO " & stTblLocal & " FROM " & stTblBE,

and then updating via rst.update.


As this is my first time working with an SQL back end, I'm working through a series of bugs. What other things am I likely to encounter?

Thanks
Adam

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

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

.

__,_._,___

Tidak ada komentar:

Poskan Komentar