By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 748 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
"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.