ACCESS FEED: RE: [MS_AccessPros] Operation must use an updateable query

Selasa, 12 Februari 2013

RE: [MS_AccessPros] Operation must use an updateable query

What is the SQL of qryWeeklyReceivedInventory? Does this query allow updates?

Duane Hookom MVP
MS Access

----------------------------------------
> From: DEmbrey@bcbsm.com
>
> The primary key for the table is a compound key consisting of the weekending and the invtype.
>
> Darrell
>
> From: Duane Hookom
>
>
> 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