Random #Deleted errors in database

[Sue22]

Hi,

I have a database which uses linked tables. When a user changes data in one of the fields which is long text occasionally when moving to another field or record the data in this field seems to get deleted without the user having done anything to delete it. The field then shows the error message #Deleted, going out of the database and back in doesn't sort it. I have to go into the table blank the word #Deleted from the offending record and then things are OK again.



Does anyone have any suggestions for why this may be happening and what I can do to stop it?

[Bob Fitz]

Is the db split.

[ranman256]

That is odd. In the form , i would set the form ALLOW DELETIONS to NO. try that.

[ItsMe]

I would say that something like this is rare if ...

The DB is split and you are using simple bound forms and bound controls.

Multiple users opening the same file and then having VBA updating records could encourage the symptom you are experiencing. Otherwise, I might suspect a corrupt control that is bound to a field and replace the control with a new one.

It may be best to rebuild the form. Create copies before doing any edits, compact and repair after deleting controls/forms and before rebuilding, yadda yadda yadda

[Sue22]

Yes the database is split.
The form is already set to allow deletions NO.
There is no VBA which updates the rcords and although the plan is to have multiple users shortly at the moment this is occurring when there is only one user accessing the database.

[ItsMe]

I would suggest deleting the control and replacing it with a new one, then.