Groups > comp.databases.ms-access > #10709

Re: Database Corruption

From	Ron Weiner <rw@domain.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Database Corruption
Date	2015-05-05 22:16 -0400
Organization	WorksRite
Message-ID	<mibtf7$535$1@dont-email.me> (permalink)
References	(3 earlier) <mhluki$tk$1@dont-email.me> <mhm0l1$9h6$1@dont-email.me> <mhm757$53u$1@dont-email.me> <mhmfog$7n8$1@dont-email.me> <mhmnnc$vm6$1@dont-email.me>

Show all headers | View raw

Ron Weiner was thinking very hard :
> Ulrich Möller expressed precisely :
>
>> Hi Ron
>>
>> i can't see any obvious problem in doing so. Perhaps you don't even need 
>> any index in tblUploadScan for a better insert performance. You should only 
>> take care of counting the records before and after the insert operations to 
>> ensure that no record has been lost.
>>
>> Ulrich
>
> We currently are counting the records immediately after committing the 
> transaction to ensure that we have really written the number of records that 
> we thought we wrote.  In order to get reasonable query performance we need to 
> have index's on the 3 Columns we are selecting on.  So those index's will 
> need to stay.  I hope to have some time later this week to code and test.  
> I’ll report back my findings.
>
> Thanks to all for your help.
>
> Rdub

We just finished testing with the new schema, and it appears that our 
corruption problems are behing us.

I want to thank all who helped.

Rdub

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 10:03 -0400
  Re: Database Corruption Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-27 08:23 -0700
    Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 11:50 -0400
  Re: Database Corruption Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-27 08:30 -0700
    Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 11:51 -0400
  Re: Database Corruption Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-04-27 08:47 -0700
    Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 11:53 -0400
      Re: Database Corruption Optimist <v.meldrew@i.do.not.believe.it> - 2015-04-29 13:25 +0100
  Re: Database Corruption CDMAPoster@fortunejames.com - 2015-04-27 08:48 -0700
    Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 11:58 -0400
  Re: Database Corruption Ulrich Möller <knobbi38@arcor.de> - 2015-04-27 18:41 +0200
    Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 13:57 -0400
      Re: Database Corruption Ulrich Möller <knobbi38@arcor.de> - 2015-04-27 20:21 +0200
        Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 14:55 -0400
          Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 16:46 -0400
            Re: Database Corruption Ulrich Möller <knobbi38@arcor.de> - 2015-04-28 01:13 +0200
              Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-04-27 21:29 -0400
                Re: Database Corruption Ron Weiner <rw@domain.com> - 2015-05-05 22:16 -0400

csiph-web