[AccessD] Dropped records...Boatloads of them

[Jim Lawrence]

Hi Janet:

An MS Access MDB demands a very stable and static environment. Wireless connection are always dropping signal, by their nature...some worse that others. Watch out for corruption and quite possibly lost records. Where at all possible use network cable and/or use a UPS. Maybe make an over-night batch file the exports, imports and re-index the offending tables...that may save some flaky records and/or tell you exactly when a record(s) was lost.

Remove all cascading code from the application, updating or deleting. Use an unique key to identify a record when updating or deleting...there is less chance of falling victim to corrupted keys.   

Of course my recommendation is to use ADO and I believe you have all the code for that.

HTH
Jim
 
----- Original Message -----
From: "Janet Erbach" <jerbach.db at gmail.com>
To: "Database Advisors" <accessd at databaseadvisors.com>
Sent: Tuesday, May 26, 2015 12:35:27 PM
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