I am having a problem with a view of a MS SQL Server table. When I try to modify certain records I get an Update Conflict error. This only happens with certain records, not every record. I have no problem modifying the data using MS Query.

For two records, I deleted them and then rekeyed the exact same data. The problem went away.

The table has three key fields: claim_number (Integer), dt_time_stamp (datetime), and payment_number (Integer).

I have fixed the problem for two records but I am concerned that this problem will affect other records.

Help?