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]

DO NOT USE: CurrentDb.Execute
Use queries.
build a query using your code, BUT replace the ME with the full path to the form object

forms!frmMyForm! txtbarcode

then all you do is, click a button to run (in a macro)
docmd.openquery "qaAddRecordFromForm"

Theres no need for code. Just Queries.

 

[GinaWhipp]

I will disagree with the no using of CurrentDb.Execute as it's all I use. That said, if you open the Table from the Frontend can you APPEND data? Are you linked to an Access database or SQL Server Backend.

 

[Ranman256]

Queries. No code needed. Even with linked SQL tables.
queries.

 

[GinaWhipp]

@Ranman256

Not sure why you have this aversion to code but since this OP is already using it we can just troubleshoot that.

 

[santhosh23]

@GinaWhipp ..Thanks for the response...yeah in front end i am able to append data in table , I am connected to access database not sql server backend. May i know how to resolve this issue now.??

@GinaWhipp @ranman256..Can i go ahead with code or shall i use query ??

 

[GinaWhipp]

What you use it up to you, just let us know before we troubleshot so we are *fixing* the correct item. So, which one do you want to use?

 

[santhosh23]

@Gina Whipp ....I am using same currentdb.execute code ..I created the fe and be from beginning and it works fine for my system ..I need to check it my colleagues machine.. thanks so much @GinaWhipp @ranman256..

 

[GinaWhipp]

Hmm, yep it could be as easy as relinking the tables.

 

[santhosh23]

@GinaWhipp ..yeah it was working fine in all machines I tested so far

 

[GinaWhipp]

Great! If you are going to work on it at home or another location you should set up the same path AND you should include some code to check those links.

 

[santhosh23]

@GinaWhipp...oh okay..should i google to get those codes ?? Another doubt is while adding the users in security tab to access the particular file .. like we have Users , Systems ..what happens if i give particular person name ?? any idea on that?

 

[GinaWhipp]

Hmm, nope, here are a few...

Reconnect Attached tables on Start-up
http://allenbrowne.com/ser-13.html

Refresh Links
http://www.mvps.org/access/tables/tbl0009.htm

Automatically relink Microsoft Access tables
http://blogs.office.com/b/microsoft...atically-relink-microsoft-access-tables-.aspx

JStreet Relinker
http://www.jstreettech.com/downloads.aspx

Not sure what you mean by your second inquiry. What does relinking have to do with adding Users?

 

[santhosh23]

@GinaWhipp...another doubt i mentioned is different one , its not related with relinking . When i share a folder in network with others we have options like adding Users , Groups , Administrators, so what happens if I give my manager name ..becoz i got my manager name in that list..but i had no idea what level of access he has on that..??? hope you got that...

 

[GinaWhipp]

Oh, you mean permissions on the Folder that has the Backend in it. Well, wherever that Backend is needs to be in a Folder on a Shared Drive where everyone has ALL permissions. Most Companies have such a drive... check with IT.

 

[santhosh23]

@GinaWhipp ..Yeah i will check them ..thank you