Just a bit of background which may help find a solution to my problem. I had this access database for a very long time and about a year ago i moved the back end to an SQL server. I ran into this problem before where when i add a new field to a table it puts a NULL value in all the previous records and then i get a message "Write conflict". So i ran a query to update all the records to 0. However i am still having a problem where i can create new records and i am also able to go into any previous records (30,000 plus) that were created before i added this field and i can edit them. However any new records that i create once i leave that record and then go back to it to modify i get this write conflict.
Thanks,
Sam