Solved Checkbox causing error when SQL Server BE (1 Viewer)

Kayleigh

Member
Local time
Today, 20:02
Joined
Sep 24, 2020
Messages
706
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.
 

Attachments

  • writeConflict.png
    writeConflict.png
    8.7 KB · Views: 240
  • tblAddress.png
    tblAddress.png
    24.1 KB · Views: 249

theDBguy

I’m here to help
Staff member
Local time
Today, 13:02
Joined
Oct 29, 2018
Messages
21,358
Hi. First thing to do is set Allow Nulls to No and assign a Default Value.
 

Kayleigh

Member
Local time
Today, 20:02
Joined
Sep 24, 2020
Messages
706
Sorted thanks (y)
 

Users who are viewing this thread

Top Bottom