can't delete record if checkbox is false



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question