Write Conflict error message when entering data into a form

[Guest]

Hi,

I get the following error appear on screen when I type data into several
related forms. The database is saved on my workplace server:

'The record has been changed by another user since you started editing it.
If you save the record, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.'

Please note that no one else is using the database or making changes as the
message suggests. Hope someone can help.

Kind Regards

Ammo

 

[OfficeDev18 via AccessMonster.com]

Do you perhaps have more than one form open at a time, and two or more of the
forms have at least one table in common in their Record Source?

Try opening only one form at a time, make your change(s) and save them, close
that form, and only then open your subsequent form for data entry.

HTH

 

[Guest]

Hi HTH,

The answer is yes to your question, unfortunately what you have suggested
will really effect the useability of the database. Is there a way of changing
some settings to the database so that the message stops appearing altogether?

Kind Regards

Ammo

 

[OfficeDev18 via AccessMonster.com]

I don't know; I'm not familiar enough with shared tables/files to answer the
question.

Anybody?

Hi HTH,

The answer is yes to your question, unfortunately what you have suggested
will really effect the useability of the database. Is there a way of changing
some settings to the database so that the message stops appearing altogether?

Kind Regards

Ammo

Do you perhaps have more than one form open at a time, and two or more of the
forms have at least one table in common in their Record Source?

[quoted text clipped - 22 lines]