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

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

Re: Database Corruption

From Ron Weiner <rw@domain.com>
Newsgroups comp.databases.ms-access
Subject Re: Database Corruption
Date 2015-04-27 16:46 -0400
Organization WorksRite
Message-ID <mhm757$53u$1@dont-email.me> (permalink)
References <mhlfhu$vp6$1@dont-email.me> <mhloqj$752$1@dont-email.me> <mhlt87$qla$1@dont-email.me> <mhluki$tk$1@dont-email.me> <mhm0l1$9h6$1@dont-email.me>

Show all headers | View raw

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

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