Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Is it possible to download field info from laptop to main computer changing the ID

Discussion in 'Information Technology' started by Wayne & Kerri Anne, Jul 28, 2006.

  1. Wayne & Kerri Anne

    Wayne & Kerri Anne
    Expand Collapse
    Guest

    Hi All

    My question is can you import field information from a laptop say which has
    the same structure as the table on a main computer.

    I have written a vb6 program that has two main tables
    One is tblworkorder which has a WOID as the Primary key field (Autonumber)
    and the second table tblWorkorderDetail has a WOID as a number field. all
    data is linked by the WOID fields.
    Is it possible to download this info from the laptop and have the main
    computer change the WOID in both tables to the next autonumber of the
    tblworkorder of the main computer. and if possible how would one do it in a
    kiss system. Very New to access 97.


    Kind Regards
    Wayne
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---Mission impossible 5 Rogue nation Theatre, Movies & Cinema Aug 12, 2015
    India Professor Bhullar's release possible after landmark SC judgement Breaking News Jan 21, 2014
    USA UPDATED! Dr. Prabjot Singh, Sikh Professor Attacked in Possible Hate Crime (2 Videos) Breaking News Sep 23, 2013
    A Shabad I came across - possible interpretations Sikh Sikhi Sikhism Aug 28, 2013
    To know God is to Love him, why this is not possible Sikh Sikhi Sikhism Mar 31, 2012

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    The by far easiest way is to change the autonumber fields from increment to
    random
    You'll then be very unlucky to get dups (and you can write pretty simple
    code to handle that)

    Another pretty simple way is the make sure that the On UPDATE Cascade field
    is checked for the reference,
    update to local WOID by the max(WOID) + 100 (or another suitable increment)
    just before the Append
    (to make sure you can lock the maintable during the process)

    The final way is to Make Recordsets with outer and inner loops handling
    WOID's 1 by 1
    (Requires pretty good knowledge of VBA/DAO programming)

    HTH

    Pieter

    "Wayne & Kerri Anne" <ker.way@bigpond.net.au> wrote in message
    news:Oy3PWAjfGHA.2188@TK2MSFTNGP04.phx.gbl...
    > Hi All
    >
    > My question is can you import field information from a laptop say which
    > has the same structure as the table on a main computer.
    >
    > I have written a vb6 program that has two main tables
    > One is tblworkorder which has a WOID as the Primary key field (Autonumber)
    > and the second table tblWorkorderDetail has a WOID as a number field. all
    > data is linked by the WOID fields.
    > Is it possible to download this info from the laptop and have the main
    > computer change the WOID in both tables to the next autonumber of the
    > tblworkorder of the main computer. and if possible how would one do it in
    > a kiss system. Very New to access 97.
    >
    >
    > Kind Regards
    > Wayne
    >
     

Share This Page