#Error in form's Notes field

Question

Hi!

I have a entry form that I can write notes in however one of the projects in my database has an error displaying #Error and when you click on my textbox it displays a pop up saying " The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time" I checked and no one else was on the database and even when asked for everyone to exit their database another day it still displayed it. It is only for one project and was out of the blue. Let me know if there is more information needed :)

Thank you!

Andrew

Answer 1

Have you done a Compact and repair on the database? If the problem is only occurring with one record, then its most likely a data corruption issue.

Answer 2

Open up the table that has that particular Notes field and see if that record contains any foreign characters,

Answer 3

This may occur if you have code trying to edit the textbox at the same time. Have you checked for that?

Hi Scottgem!

I've checked for any code that may be editing the textbox but I see none. Is there somewhere you think I should check? None of my macros are changing the data as well. 

The entry form seems normal and the other 100+ projects are working fine just that one project it has that error even when I go to the Table where it is stored it has same #Error and same message when you click on it.

What do you think?

Answer 4

This may occur if you have code trying to edit the textbox at the same time. Have you checked for that?