disappearing records

  • Thread starter Thread starter walter Levine
  • Start date Start date
W

walter Levine

I have a client who is claiming that some database
records have gone missing, more like two or three over
the past few months as my applications have been phased
in. My programs don't do anything even remotely
resembling a delete of records. Does anybody have any
ideas or thoughts on how to approach this problem?
In general, the users do not have the knowledge to go
into Access datasheet and delete records.
Thanks for any Input.
Walter
 
I have a client who is claiming that some database
records have gone missing, more like two or three over
the past few months as my applications have been phased
in. My programs don't do anything even remotely
resembling a delete of records. Does anybody have any
ideas or thoughts on how to approach this problem?
In general, the users do not have the knowledge to go
into Access datasheet and delete records.
Thanks for any Input.
Walter
Click to expand...

Ignorance is all it takes, sometimes... It's not that hard for a user
to unintentionally or unknowingly delete data, unless your user
interface goes to a lot of effort to prevent such deletion. I've
encountered at least one user who would delete records from a Form
(using the menu option, though they could have used the record
selector) simply because he didn't want to see that particular record
in a Report; he didn't realize that deleting from the Form also
deleted from the Table.

I've seen quite a few posts over the years suggesting that Access
loses records for no discernable reason, and indeed it may - but in
almost all cases I'm pretty sure that the records are in fact being
deleted.
 
I concur with John Vinson. The sudden removal of records usually means
someone deleted the information. However, if you have any queries that use
multiple tables to return information, it is possible there is some
condition that may prevent certain records from showing. Are you positive
that the records do not exist in the table or is it that the record doesn't
show within a form or report that has been based on a query?
 
No, I am not looking at a query. I am looking at the raw
table, and the records are not there. On the form's
property sheet, the AllowDeletions property is set to NO.
I assume that means that deletions are not allowed,
through the form at least.
thanks for your input.
Walter Levine
 
Back
Top