Access requires the joins to be on primary/foreign key fields and/or unique indexes in order to be updateable. What's your relationship?
There may be workarounds.
Duane Hookom MVP
MS Access
----------------------------------------
> From: DEmbrey@bcbsm.com
>
> Greetings,
> Why does the following sql return the "Operation must use an updateable query" error.
>
> UPDATE tmpWeeklyOpenInventoryReport AS tbl INNER JOIN qryWeeklyReceivedInventory AS qry
> ON (tbl.InvType = qry.InvType) AND (tbl.WeekEnding = qry.[Week Ending]) SET tbl.Received = qry.Received
>
> Darrell
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar