Record changed by another user error

[Seth Schrock]

I have a database with an Access 2010 FE and a SQL Server BE. In one of the forms, I have a subform as well. For some reason, whenever I try to save it explicitly, I get an error that the record has been changed by another user and it only gives me the option to drop the changes. I'm currently running in a test environment that only I have access to use it. I don't have any other test systems running. No code modifies the recordset directly, only sets values in the controls that are bound to the recordset. I checked, and there aren't even any SELECT queries being run on the table that the form is based on. There is a default constraint on the table in SQL Server, but I'm passing a value to that field through the form so that shouldn't be coming into play.

I'm at a loss of what else to look at to find where the other user could be coming from.

[zmbd]

This is very old (ACC2000); however, I wonder if they ever fixed the FP/Bit bug? http://support.microsoft.com/?id=280730

[Seth Schrock]

It turns out it was a bit field that I don't touch in the form I was working with (the parent form). There are two bit fields in the table. I work with only one of them in this form and it was set to not allow null, but the other one was set to allow null. So I have setup a default constraint on the other field to set new records to false and set it to not allow null. I had actually ran into this before when I first switched over to SQL Server and I checked the one bit field, but I forgot about the other one.

Thanks Z.