Single table Multi-form Issue

[Tupacmoche]

Hi Form Masters,

I keep getting this Access message: The data has been changed. Another user edited this record and saved the changes ... We have all seen this before and I understand why its happening. I'm updating a table using several forms since the data is broken up into logical chunks on forms and it is over kill to put the columns into different tables. Simple put is there a way around this message? Also, when it pops up the checkbox that was being 'checked' remains unchecked. Can this be prevented along with suppressing the message?:banghead:

 

[isladogs]

There are a number of reasons why this occurs.
The one that caused me most grief to pin down was having Boolean fields in a SQL Server backend with a split database. If relevant to you, check whether you have any Boolean fields without a default value. If so, set a default for each.

 

[Tupacmoche]

Hi Ridders,

Yes, in fact the message is happening on a bit field, but I believe that, I set the default to 0, but I will check.

 

[isladogs]

Hi Ridders,

Yes, in fact the message is happening on a bit field, but I believe that, I set the default to 0, but I will check.

You should always set the default for all boolean fields in Access & SQL Server.
In access, boolean fields can only be true or false
However in SQL Server, they can also be null.

The reason why it matters for linked SQL tables with no default values is because Access can't interpret any null values so throws a wobbly in the form of the very enigmatic message you observed.

Make sure all existing values are NOT null. Update to default e.g. false in SQL Server

It took me months to pin down the cause (several years ago). Since then I've never seen the message