[AccessD] Dropped records...Boatloads of them

[Stuart McLachlan]

Sometimes!  I've also had situations where only  opening the table in code, stepping through 
the records and writing them out to a linked table in another database worked.


On 26 May 2015 at 14:12, Rocky Smolin wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>