Please Help!! Field cannot be updated. (Error 3164)

i have a database that has been working for for over a year.

i have a form that is linked to a qry. when the form opens it shows a blank
record. when you type in data in any of the fields you get a msgbox "Field
cannot be updated". on clicking OK this message box appears another 4 times
then the record can be edited as if the message boxes dint appear.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13280-please-field-cannot-updated-error-3164-a.html

whats more strange is that i have approx 40 different backups of this
database. Saved as i was developing it. All these databases have the same
fault but didnt yesterday.

i dont know whats going on? has this happened to anyone before or can anyone
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280
help??? please.

Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

On Fri, 14 Jul 2006 14:30:01 -0700, StuJol
wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280

>i have a database that has been working for for over a year.
>
>i have a form that is linked to a qry. when the form opens it shows a blank
>record. when you type in data in any of the fields you get a msgbox "Field
>cannot be updated". on clicking OK this message box appears another 4 times
>then the record can be edited as if the message boxes dint appear.
>
>whats more strange is that i have approx 40 different backups of this
>database. Saved as i was developing it. All these databases have the same
>fault but didnt yesterday.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280
>
>i dont know whats going on? has this happened to anyone before or can anyone
>help??? please.
>

Try Tools... Compact and Repair; and then if that doesn't work, try
rebuilding the Query upon which the form is based.

John W. Vinson[MVP]

It's 2012 and I have this same issue with my Access 2010. No solution was ever found?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280

Error pops up 3 to 4 times and then you can create a record. This happens only at the form level (in a combo box). No issue when adding record directly on the query or table.