record has been changed by another user

[GA]

Any help would be gratefully received.

In an mdb front end to a sqlserver backend, I have a form with a tab
control containing a number of tabs some of which have sub forms on them.
It worked fine until recently and now when trying to update any data I get
"This record has been changed by another user since you started editing
it."

I have no problems changing the data directly in either the sqltable or
the sqlview to which the mdb linked table points.

I get the error if I try to change any data the Access linked table which
indicates that it's not the form that is at fault.

I've deleted the linked table and re-linked it. I use a composite of
'payroll_number' and 'surname' to create the key when linking and the
Access table shows as being updatable.

I'm at a loss now so can anybody suggest what might be wrong please.

 

[GA]

...aarrrgghhhh - I knew this all along but the brain cells are leaking. In
case it's of interest to anyone else -

Allowing Null values in a bit (Yes/No) field in sql causes problems to an
Access front end.

I recently added several bit fields to my sql table and forgot!!

Updated all the relevant fields to false and then changed the sql table
design and everything works again 8^)
GA

Any help would be gratefully received.

In an mdb front end to a sqlserver backend, I have a form with a tab
control containing a number of tabs some of which have sub forms on them.
It worked fine until recently and now when trying to update any data I get
"This record has been changed by another user since you started editing
it."

I have no problems changing the data directly in either the sqltable or
the sqlview to which the mdb linked table points.

I get the error if I try to change any data the Access linked table which
indicates that it's not the form that is at fault.