Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Database Corruption

From Ulrich Möller <knobbi38@arcor.de>
Newsgroups comp.databases.ms-access
Subject Re: Database Corruption
Date 2015-04-28 01:13 +0200
Organization A noiseless patient Spider
Message-ID <mhmfog$7n8$1@dont-email.me> (permalink)
References (1 earlier) <mhloqj$752$1@dont-email.me> <mhlt87$qla$1@dont-email.me> <mhluki$tk$1@dont-email.me> <mhm0l1$9h6$1@dont-email.me> <mhm757$53u$1@dont-email.me>

Show all headers | View raw

Am 27.04.2015 um 22:46 schrieb Ron Weiner:
> Ron Weiner pretended :
>
> Wow, just had a brain storm.  Thought I'd run it past all of you.
>
> What if I create a new table (tblUploadScan) with the same structure 
> at the tblScan table we are currently using but without the AutoNumber 
> column and without a PK?  I am thinking if there is no AutoNumber 
> column and no Primary key, there is no concurrency problem.  All of 
> the other columns that have Index’s allow for duplicate values.
>
> Theoretically all of the data from multiple scanners goes in there 
> without any chance of a AutoNumber getting out of sync.  Then later 
> after all of the rows have been uploaded to this scratch table I can 
> run a simple append query to get em all in the tblScan table.  Truth 
> is I do not use the ScanID column for anything other than to have a PK 
> in that table.  In our Schema it has no relationship with anything.
>
> Does anyone see a problem with this?
>
> Thanks
> Rdub

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

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next 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