Records showing as '#Deleted' in one form but not another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

maddman - 23 Sep 2004 16:03 GMT

I have an odd problem with my database, and was hoping someone could
point me at the problem.

We have an access database that is used by several people to input
data. Users have reported some of the records in their forms
(Datasheet view) are showing up as "#Deleted", though no one should be
deleting records from here. Further, the messages show up only on
certain users' screens.

Is this a result of corruption from having multiple people in it at a
time (I know, I know, but these things happen), or is someone deleting
records on us? Or could it be something different entirely?

Any advice to solve this one would be greatly appreciated.

Reply to this Message

Allen Browne - 23 Sep 2004 16:17 GMT

Does this only happen temporarily, i.e. when one user deletes a record,
another sees #Deleted, but it's fine later? If so, it's nothing to worry
about.

However, if the #Deleted always shows up in the same form, and in the same
records, it can indicate a corruption. To remove the corruption, see the 3rd
symptom in this article:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have an odd problem with my database, and was hoping someone could
> point me at the problem.
[quoted text clipped - 10 lines]
>
> Any advice to solve this one would be greatly appreciated.

Reply to this Message

maddman - 27 Sep 2004 14:02 GMT

> Does this only happen temporarily, i.e. when one user deletes a record,
> another sees #Deleted, but it's fine later? If so, it's nothing to worry
> about.

They shouldn't be deleting records at all, but when I set the forms to
prevent deletions the problem magically vanished. So that explains
the mystery I suppose. Thanks!

Reply to this Message