Unexplained Run-time error 3113

  • Thread starter Thread starter DinosRose
  • Start date Start date
D

DinosRose

I've had several users of a tool I designed reporting that they are getting a
Run-time error '3113' Cannot update '(expression)'; field not updateable
message when running a particular process. I have been unable to duplicate
the error when running the process on my PC. One user provided me with a
screenprint that showed the error occurred on the line of code shown below.
Both objects involved in the sql are tables; Auditor Ref is a linked table in
another Access database. And there are no "expressions" involved. So I'm
not sure why this error is occurring. Any ideas?

DoCmd.RunSQL ("UPDATE tempStat INNER JOIN [Auditor Ref] ON (tempStat.Auditor
= [Auditor Ref].Auditor) AND (tempStat.Section = [Auditor Ref].Section) AND
(tempStat.ReportDate = [Auditor Ref].ReportDate) AND (tempStat.ReportType =
[Auditor Ref].ReportType) SET [Auditor Ref].[# Claims] = [CountOfRX #],
[Auditor Ref].[$ Claims Billed] = [SumOfBILLED Amt];")
 
Couple things to check, do you have the same tables as they do? Maybe
invalid data in one of their tables that you don't have. Also I would
rename fields to eliminate all # and $,
From access help.
Access reserved symbols
The following symbols must not be used as part of a field name or as part of
an object name:
 
Back
Top