can't delete record if checkbox is false

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

In a table in access I can delete a record when my checkbox field is
True or -1. When I try and delete a record where the field is 0 then
it gives me an error:

"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

This is a copy that I am only working in. I have the checkbox default
value =0. The datatype is set to Yes/No in access which on my sql
backend it is Bit, NULL.

Has anyone had this problem? It seems like it is something simple, but
I can't figure it out after hours of trying. Any help would be
appreciated. Thanks.
 
I figured this out. Since this field was added after the table was
created I had allot of NULL values on the sql backend even though it
showed correct in the access table (probably since i had the checkbox
defaulted to 0). I ran an update script on the backend to change all
the NULL values to 0 (or false) and now i can delete the records in
access. In case anyone else is having a similar issue. FYI.
 
Back
Top