Run-time Error 3073 : Operation must use an updateable query

[Santhosh23]

Hi ..

I created a db in access in which the users login and enter few information in subform which gets stored into a table. Everything was working fine. I just splitted my db into front end and back end . I used my front end to work the same.. but when i click the save button I got an 3073 error that operation must use an updateable query. The query is given below ,

CurrentDb.Execute "INSERT INTO RecordTable([User],[Barcode],[ToolCareJob],[Worked On Activity],[Start Time],[End Time],[Work Time])" & _
"VALUES ('" & Me.txtUser & " ' ,'" & Me.txtbarcode & "','" & Me.cboToolcarejob & "','" & Me.cboWorkedonactivity & "','" & Me.txtStartTime & "','" & Me.txtEndTime & "','" & Me.txtWorkTime & "')"

When i googled i found that it maybe due to read/write permissions but while creating both front end and back end I made it to full control... i wonder where did I go wrong

Anyhelp on this issue is really appreciated...

 

[ranman256]

dont use CurrentDb.Execute.

just run an append query and run it via
docmd.openquery "qaApdQry"

 

[Micron]

creating both front end and back end I made it to full control

You made what full control? Settings in a .mdw file (outdated now)? A network folder? If a folder, does everyone who uses the db have full control on the network folder?
I'm guessing you put the back end in a different folder that isn't set up correctly:
- if you made no other changes when you split the db
- because you say it was working before
- you have no joins or WHERE clause
- your values seem to be coming from a form (an append query based on a non-updateable query such as a totals query will produce this problem).

 

[james_lankford]

is RecordTable in the back end

is your vba code in the front end

does RecordTable has a primary key