Access 2010 VBA - Runtime 3073

Asked Oct 24 '12 at 13:51

Active Oct 26 '12 at 03:16

Viewed 59 times

Possible Duplicate:
Operation must use an updatable query. (Error 3073) Microsoft Access

I am using the code below:

CurrentDb.Execute "INSERT INTO calldata([username], [reportnumber], [reportdate], [custconcern], [cc], [as]) " & _
" VALUES('" & Me.cboopenedby & "','" & Report_Number & " ','" & _
Me.txtopenedon & "','" & Me.cboconcern & " ','" & strCustconcernfixtxt & " ','" & strActionfixtxt & "')"

And it is working fine in Access 2007 but when given to someone in 2010 they get:

Runtime Error 3073 - Operation Must Use an Updateable Query

Any ideas?

edited May 23 '17 at 12:21

Community

asked Oct 24 '12 at 13:51

James Deadman

I looked at that but since I am not using a WHERE in the statement it is not Jet – James Deadman Oct 24 '12 at 14:13
check the types of values you are passing - is `[report_number]` a string? – SeanC Oct 24 '12 at 14:22
Silly question... Is calldata a table or a non-updateable query? – Daniel Oct 24 '12 at 16:11

Access 2010 VBA - Runtime 3073

0 Answers0