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

Rabu, 13 Februari 2013

RE: [MS_AccessPros] Operation must use an updateable query

Darrell,

As you have discovered an Access query with any aggregates will never be updateable. Some times we are stuck using domain aggregate functions like DSum() or other solutions.

Duane Hookom
MS Access MVP

----------------------------------------
> From: DEmbrey@bcbsm.com
>
> The SQL for qryWeeklyReceivedInventory was a totals query. I am changing to a select query that pulls the data from the totals query to see if that resolves the problem.
>
>
> Darrell
>
> From: Duane Hookom
>
> 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