469,657 Members | 1,841 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,657 developers. It's quick & easy.

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

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.
Nov 13 '05 #1
2 1874
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

--
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.

"maddman" <ma********@yahoo.com> wrote in message
news:be**************************@posting.google.c om...
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.

Nov 13 '05 #2
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<41***********************@per-qv1-newsreader-01.iinet.net.au>...
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!
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ardith via AccessMonster.com | last post: by
1 post views Thread by bigabytes | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.