#Error

[Guest]

I have a small Access 97 database application that uses a couple of different
forms to enter and update information. The last enterable field on all of the
forms is a notes field (memo format). On occasion, the memo field is getting
corrupted. The text will disappear and the field will contain #Error.

When the record is accessed the following message appears:
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

So far the only solution I have is to delete the record from the database. I
have searched high and low for an answer as to why the error is occurring to
mo avail.

Does anyone have an idea of what is causing this problem???

Thank You

(e-mail address removed)

 

[Guest]

The error message that says "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same data
at the same time." Has to do with what is called concurrency, the database
will not let you and another person access the same record at the same time.
I don't know what is causing your memo problem, however but i have heard
that the Memo field in Access is scary.