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 f
ront end I get an error tha
t 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 m
oved 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 Zhou