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

#1 (**permalink**) 28-Jul-2006, 08:35 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13280-please-field-cannot-updated-error-3164-a.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280
fault but didnt yesterday.

i dont know whats going on? has this happened to anyone before or can anyone
help??? please.

#2 (**permalink**) 28-Jul-2006, 08:35 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13280
>fault but didnt yesterday.
>
>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]

DraconXanathos · #3 (**permalink**) 08-Aug-2012, 21:50 PM

It's 2012 and I have this same issue with my Access 2010. No solution was ever found?

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.