This record has been changed by another user since you started editing it

[BennyLinton]

I know this is a frequent topic but I've not been able to solve this from other posts... please help!
"This record has been changed by another user since you started editing it"
I have a split database (SQL Server backend) and on the Access side I have a main form with two subforms with various combo boxes (pulling from tables themselves). Each of the two subforms writes back to different tables rather than the table the main form writes to. One of the subforms brings up the error and one does not. I can't find any difference between the two though. Any ideas?

 

[Ranman256]

You can get this error even if you are the only person in the db.
Access gets confused due to something on the record.

If the master form is connected to the sub forms correctly there should not be errors.
Is the master form bound to a record?
Are the sub forms bound to a sub table related to the Master record on the form?
This method does not give errors.

 

[BennyLinton]

This database is only open by myself presently so i know it is not another user's accessing of the record. Both subforms get their data from a query written to their respective tables. Both forms revolve around a field common to all which I call 'peopleID'. So when i pull up a record on the master form the two subforms populate correctly every time.

 

[Minty]

Are the queries for the sub forms using the master tables peopleID (the PK), or the peopleID(FK) from the Child tables? It should be the latter.

 

[BennyLinton]

Both queries for the subforms have 'peopleID' in them. In the SQL Server tables it is not a FK though in either, but one form subform is updating to its table correctly, but the other isn't.

 

[Minty]

What if you try and update the second subform before the first one ? Same result but the other way around?

 

[BennyLinton]

I can make a change in the one that is working correctly in any sequence relative to the one that isn't working and the result is the same. I have an update button on the main form, but there is no code of any significance since I'm using Dynaset for all.

 

[bastanu]

Any boolean fields in the SQL tables (on which the subforms are based on) that might not have the default set to 0?

 

[BennyLinton]

Any boolean fields in the SQL tables (on which the subforms are based on) that might not have the default set to 0?

That was it... I set the defaults in SQL Server to 0 and it works great now... THANKS!

 

[vonevilstein]

It might be four years later but I've registered on this site for express purpose of thanking the OP (for the wording of the question AND confirming the answer) and bastanu for the answer. If I was being kind to myself I would say that this thread has saved me a day of trying to find the answer, if I was being realistic I would say it's saved me a week . Thanks both!

 

[bastanu]

Made my day!