Access Error Field cannot be updated. (Error 3164)

[George D]

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.

 

[John W. Vinson]

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.