If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Error Field cannot be updated. (Error 3164)
I had a form based on a query and did some revisions to the underlying
tables. I've reset all the existing relationships, but now every time I try to add a new record I get the Access error 3164. There is no one else using this database as it isn't in production yet and I've checked the control proberties on the form and the control is set to Enable: Yes, Locked: No. I tried compacting several times to no avail. I then removed the offending control from form, but now the next control gives me the same error ( this control didn't have the error previously if I bypassed the first control which was generating the error. I even went back to a previously saved version of the database and the problem now exists there as well. This version had been working perfectly previously. If anyone can shed some light on what's going on, and how to fix it, I would be eternally greatful. |
#2
|
|||
|
|||
Access Error Field cannot be updated. (Error 3164)
On Thu, 8 May 2008 11:59:04 -0700, George D
wrote: I had a form based on a query and did some revisions to the underlying tables. I've reset all the existing relationships, but now every time I try to add a new record I get the Access error 3164. There is no one else using this database as it isn't in production yet and I've checked the control proberties on the form and the control is set to Enable: Yes, Locked: No. I tried compacting several times to no avail. I then removed the offending control from form, but now the next control gives me the same error ( this control didn't have the error previously if I bypassed the first control which was generating the error. I even went back to a previously saved version of the database and the problem now exists there as well. This version had been working perfectly previously. If anyone can shed some light on what's going on, and how to fix it, I would be eternally greatful. Not all queries are updateable. Please open the query in SQL view and post the SQL text here, and indicate which field it is you're trying to update. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|