Write Conflict

[Vic]

I'm having trouble with a subform where the user tries to
change the data in the subform and gets a write conflict
error. The parent form data is saved correctly. This is
the error that I'm getting:

This record has been changed by another user sinc eyou
started editing it. If you save the record, you will
overwrite the changes the other user made.
Copying the changes to the clipboard will let you look a
the values the other user entered, and then paster your
changes back in if you decide to make a changes.

My database is in SQL Server and I'm linking the access
db to SQL server. I do not have this in SQL Server, just
in Access and I don't understand why this is happening.
Please help.

 

[Vic]

I figured out what happend. I had added a field in SQL
Server with a data type bit. The bit datatype was
causing access to messed up. I changed it to an int and
it is fine now.

Thanks...