Error editing Access form with SQL Bit fields

I have had trouble in all versions of MS Access, currently xp with fields in an sql table that are defined as bit fields and in access as yes/no fields. When trying to edit a record from an access form, it says the record has been edited by another user, copy the data to a clipboard or abort. If I change these sql fields to varchar(1) or char(1), this problem goes away...Is there any way to use bit fields without this error?

Bit fields are a bit tricking. They actually return true/false, although they go into the db as 1 or 0. Are you checking for true/false or 1/0?

SQL is not happy saving records with bit fields set to null. Access reports the fields as false - even though it's null!

Make sure you explicityly set the bit field to True or False.

There can also be problems with float fields too!