[AccessD] Dropped records...Boatloads of them

Rocky Smolin rockysmolin at bchacc.com
Tue May 26 16:12:14 CDT 2015


Would compact and repair restore you think?

r 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Tuesday, May 26, 2015 1:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Dropped records...Boatloads of them

Yes,  that can happen through a dropped connection when data is being
written.  I've seen uit happen occasionally.

You get a corrupt index. The data is still there, but Access can't find it.

   

On 26 May 2015 at 14:35, Janet Erbach wrote:

> 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
> 


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



More information about the AccessD mailing list