Solved Checkbox causing error when SQL Server BE

[Kayleigh]

Hi
I've come across an annoying error which has not happened previously.
My MS Access DB recently migrated to SQL Server successfully. I have since added various fields of varying field types using SSMS. I noticed the checkboxes would come up as textboxes on forms so I would insert a checkbox and assign data source to the field - field type is bit.
However in one table whenever I tried adding the boolean field, the form would result in a Write conflict. Tried several ideas like here but not figured out how to resolve.
Appreciate any input here as I am unable to add the field to this table.

 

[theDBguy]

Hi. First thing to do is set Allow Nulls to No and assign a Default Value.

 

[Kayleigh]

Sorted thanks

 

[theDBguy]

Sorted thanks

Good luck with your project.