Weird write error problem with SQL and Access 2002

[WB786]

Ok this is really weird and I can't seem to figure out the problem. On my form (Access 2002) I have a check box. Then I needed to add more check boxes so I added more values to my SQL server. Added the check boxes on the form.

But when I try to go to the next record it say I have a write conflict and another user has modifed the record. And either to copy or drop changes. Now if I remove the values for the new check boxes from my query the form is based on it works fine.

I looked on my SQL 2000 server and matched it with my orginal check box entry. It is the same (it is a bit field).

I am totally stumped as I have fields that are bit on other forms that work fine. I even tried rebuilding the form but no go.

Any ideas???

Thanks,
WB

 

[swampBoogie]

Post in the correct forum. This has nothing to do with ANSI SQL.

 

[WB786]

I think I was half asleep when I posted this. THANKS!!