Disappearing Data

J

Jeff@Tufts

I'm having data disappear on me. Users will enter data in a form and then
run a report. Several days later after entering more data and running
additional reports and then cross checking the reports only to find that data
the was entered has disappeared. PLEASE HELP!
 
J

Jeff Boyce

Jeff

"Disappeared" ... from the reports? Or from the underlying tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff@Tufts

I don't know. The data has been re-enter.

Jeff Boyce said:
Jeff

"Disappeared" ... from the reports? Or from the underlying tables?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
J

Jeff Boyce

If the data was 're-entered' into the same table(s) it was originally in,
and if the data actually never left those tables, but simply didn't appear
in the reports, then you'll have "duplicate data" in the table(s).

This is something you can check for.

(by the way, in several newsgroup postings in the past on the topic of
disappearing data, the eventual cause has turned out to be inadvertent
deletion by well-intentioned but poorly-trained users ... after all, who
would want to admit to having killed the data?!)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff@Tufts

Thank you.

Jeff Boyce said:
If the data was 're-entered' into the same table(s) it was originally in,
and if the data actually never left those tables, but simply didn't appear
in the reports, then you'll have "duplicate data" in the table(s).

This is something you can check for.

(by the way, in several newsgroup postings in the past on the topic of
disappearing data, the eventual cause has turned out to be inadvertent
deletion by well-intentioned but poorly-trained users ... after all, who
would want to admit to having killed the data?!)

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
Top