Operation Must Use An Updateable Query

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have this under a different post, but I have progressed
from the original problem so I figured I would repost...

"Operation Must Use An Updateable Query"

If I remove the join and do a simple update comment feild
to hi where empl# = 5 it works fine, so I assumed it
must've been the join that screwed me up.

Update Local INNER JOIN Remote ON Local.[Employee Number]
= Remote.EMPLOYNUM set Local.badge = remote.badgeid

After looking up the error I think my problem may be that
there are multiple rows in the Local table with the same
employee number.

Can an update be done on a many-to-one join?
 
Is Remote.EMPLOYNUM the primary key? If so, the update should work. If
not, Access considers it a Many-Many join that is not updateable.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
I must be stewnad....
I didn't have any primary key on the local table, and
there was no unique identifier.....
I added an index column as autonum and it operates as one
would expect....
thanks
-----Original Message-----
Is Remote.EMPLOYNUM the primary key? If so, the update should work. If
not, Access considers it a Many-Many join that is not updateable.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
I have this under a different post, but I have progressed
from the original problem so I figured I would repost...

"Operation Must Use An Updateable Query"

If I remove the join and do a simple update comment feild
to hi where empl# = 5 it works fine, so I assumed it
must've been the join that screwed me up.

Update Local INNER JOIN Remote ON Local.[Employee Number]
= Remote.EMPLOYNUM set Local.badge = remote.badgeid

After looking up the error I think my problem may be that
there are multiple rows in the Local table with the same
employee number.

Can an update be done on a many-to-one join?
Click to expand...


.
Click to expand...
 
Back
Top