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

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