Web Development

The most common cause for that particular error is no primary key on the table. What's it's saying really is it can't find the data that is to be changed anymore. For the chnage it's doing
Update Table set field = new_value, ... where . If the where clause identifies a different record or more likely a set of records in a different order. This message pops up as as an ooher, somethings gone wrong.

ODBC has an option where you can log everything that goes through it (on the dsn set up). Dumpls it all into a named text file.
P.S. if you use it don't forget to turn it off, otherwise your system gets slower and slower and you get less and less disk space.

The issue was a bit field that did not have the default value set to something. Access did not like it having a null value.

This question was closed by the author