ma access 3073 error operation must be an updateable query

[nicklewis]

hi can anyone help with this problem?

what im trying to do is just do some basic calculations which did work beofre attempting an upsize and now has decided to stop funtioning and reporting the error above. what is this acctually refering too then?

 

[PHV]

What is the SQL code of your Update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BNPMike]

When you say "upsize", do you actually mean you are migrating to MS SQL Server?

 

[nicklewis]

yes sorry i am migrating to sql server

 

[nicklewis]

UPDATE ShiftType INNER JOIN ((ProductInformation INNER JOIN ((Plant INNER JOIN (([Date] INNER JOIN Downtime ON Date.DateId = Downtime.DateId) INNER JOIN [Order] ON Date.DateId = Order.DateId) ON (Plant.PlantId = Downtime.PlantId) AND (Plant.PlantId = Order.PlantId)) INNER JOIN Product ON (Date.DateId = Product.DateId) AND (Plant.PlantId = Product.PlantId)) ON (ProductInformation.ProductInformationId = Order.ProductInformationId) AND (ProductInformation.ProductInformationId = Product.ProductInformationId)) INNER JOIN Shift ON (Plant.PlantId = Shift.PlantId) AND (Date.DateId = Shift.DateId)) ON (ShiftType.ShiftTypeId = Downtime.ShiftTypeId) AND (ShiftType.ShiftTypeId = Shift.ShiftTypeId) AND (ShiftType.ShiftTypeId = Product.ShiftTypeId) SET Shift.ShiftLengthOPE = [Shift]![TotalShiftLength]-[Downtime]![Lunch/Dinner]-[Downtime]![DevelopmentOrder]-[Downtime]![Meetings], Shift.ShiftLengthTE = [Shift]![TotalShiftLength]-[Downtime]![Lunch/Dinner], Product.PacksProduced = [Product]![CasesProduced]*[ProductInformation]![PacksPerCase], Product.TECalculationp1 = [ProductInformation]![BudgetStaffingLevel]/[Product]![ActualStaffingLevel], Product.SlowRunningCalculationp1 = [Product]![RunSpeed]/[ProductInformation]![MaximumThroughput];

BUT THIS IS COMING UP WITH THE SAME ERROR ON ALL UPDATE QUERYS

 

[BNPMike]

I don't use MS SQL Server but I've seen this happenning in other posts - you need something like a unique index or primary key declaration on the target join fields. Experiment with that or do some searches on these forums.

 

[cmmrfrds]

UPDATE ShiftType
SET Shift.ShiftLengthOPE = [Shift]![TotalShiftLength

You are saying to update the table ShiftType, yet the Set statement is refering to the Shift table. You need to update the table you pick to update.

Also the ! is not valid in sql server. A hierarchy is deliniated by .

[Shift].[TotalShiftLength