There is a known problem with Access linked to a SQL back end that can exhibit this behaviour.

If you have a bit column in the table that does not have a default value, Access will struggle.

Check the definitions for your tables - set the default value of any bit fields to 0, then update the table(s) to set the value of the bit fields to 0 where the current value IS NULL