Write conflict

[Guest]

I have a form bounded to a linked SQL table.
This form has a checkbox field. When checkbox is checked, 3 fields are
updated.
One field is autofilled with word "Approved, 2nd field autofills timestamp,
3rd field autofills users name. This process works fine on an Access table
thats not linked to a SQL table but when I bound the form to the
corresponding linked SQL table, I receive a "write conflict". The following
is the exact error.

"The record has been changed by another user since you started editing it.
If you save the record you will overwrite the changes the other user made.
Copying the changes to a clipboard, will let you look at the values the other
user entered and then paste your changes back in if you choose to make
changes."

SAVE CHANGES button IS DISABLED,
COPY TO CLIPBOARD & DROP CHANGES button are enabled.

Question 1. How can I disable this box and if I cant how come SAVE CHANGES
button is disabled?

Question 2. I am the only one using the development table, why am I
receiving this error message?

thank you for any help.

 

[Guest]

I ran into that one myself. The error occurs whenever you have a BIT data
type in SQL (in Access, you'd make it Boolean) for a checkbox. SQL freaks
out about NULLS in BIT fields.

Open your database in SQL, and set the default value for your BIT field to
0.

Then run an update query in Access to set the values of all those fields to
0. (If you want, you can use an "isnull" criteria to only overwrite the ones
that are null.)