Another user has edited the record

I have an access front end and a SQL 2000 backend. In the backend I changed a ntext field to a text field using a script and it then placed the field at the end of the field list. when I try to make a change to a record on the front end I get an error that another user has edited the record and must re-edit it. I can then make a change to the record. If I do a refresh I then get the error again. I then moved the text field back into it's original position and the error went away. Can anyone explain this?Hi Doug:
I think if it is possible, please show use your error ID, then we can
get more information about the error.
Best Wishes
Wei Ci Zhousql