[AccessD] Dropped records...Boatloads of them

[Rocky Smolin]

IMHO it seems very unlikely. Without corrupting the database.

I did have one incident years ago where thousands of records disappeared
from a database.  Turns out a naïve user wanted a subset to the data so she
wrote a query that retrieved all the records in the table and then just
deleted the ones she wasn't interested in, assuming that the records were
deleted from the query and not the table.

It took a while to ferret out exactly what happened.

R
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Janet Erbach
Sent: Tuesday, May 26, 2015 12:35 PM
To: Database Advisors
Subject: [AccessD] Dropped records...Boatloads of them

Hello all -

I've corresponded with you all in the last couple of months about records
dropping from an access database in a manufacturing environment.  About
once a week we'd find 1-2 dropped records in a tool crib database.   We
installed UPS's in the area where this was happening and...fingers
crossed...so far so good.  No dropped records since they went in 3 weeks
ago.

Today I learned that a manufacturing scrap database was missing records,
too.  868,105 records to be exact:  All records from 2014 and several months
worth from 2015.  Thankfully I was able to restore them from a shadow copy.

The likelihood of an end-user deleting all that data manually is so slim
that I don't even consider it a possibility.  Can a noisy wireless network
environment and/or power brown-outs cause such a large chunk of data to go
missing like that?

Janet Erbach
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com