write conflicts & Jet engine error messages on some records and not on others
Posted on 2011-09-23
i've come across a problem on a linked table (from a SQL server 2k backend) in an MDB file.
for this particular table, the majority of the records can be edited, deleted and i can also add new ones as well. however, for a very small subset, i cannot with the write conflict and "Jet database stopped" messages.
i deleted and relinked the table, i checked the permissions on the SQL server, and made sure there was a unique identity on the table as well.
the interesting fact is that the records are uneditable and undeletable were created via a form, and each time each was created, the write conflict error would pop up, but the record would still be saved (each uneditable and undeletable).
any ideas? thanks!