Welcome to SPN

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

Sign Up Now!

Transfer data from one database to another ?

Discussion in 'Information Technology' started by SpookiePower, Jul 28, 2006.

  1. SpookiePower

    SpookiePower
    Expand Collapse
    Guest

    I have made an customer database for my work, that runs just fine.
    Now one of my users want me to make an access program
    on his laptop where he can enter new customers. When he
    then return to his job he want to be able to transfer the new customers
    from his laptop to the database on his work. I have never tryed to
    transfer data from one database to another, but how can it be done ?
    And if so, can it be done in a simple way, so he can do it by him self
    ?



    My PhotoGallery
    www.photo.activewebsite.dk
     
  2. Loading...

    Similar Threads Forum Date
    Soul transfer to another body Questions and Answers May 10, 2014
    Sikh Guruship transfer Sikh Sikhi Sikhism Mar 13, 2010
    Transfer of Sikh "Guruship" Sikh Youth Mar 13, 2010
    Sikh News SC issues notices to Punjab govt on Tytler's plea for case transfer (New Kerala) Breaking News Sep 9, 2008
    Sikh News Nine IAS officers transferred in Punjab (Outlook India) Breaking News Aug 29, 2008

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    There are several ways. The simple way is to append the new data to the
    existing tables. Do that by linking the tables from the laptop to the office
    system (or just copying the file and linking it) then running an Append
    query which takes only the data entered after a specific date/time.

    You can also use replication:

    http://download.microsoft.com/download/access2000/whitepap/1.0/win98me/en-us/replfaq2k.exe

    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "SpookiePower" <boxjunk2600@gmail.com> wrote in message
    news:1153052839.289466.32780@s13g2000cwa.googlegroups.com...
    >I have made an customer database for my work, that runs just fine.
    > Now one of my users want me to make an access program
    > on his laptop where he can enter new customers. When he
    > then return to his job he want to be able to transfer the new customers
    > from his laptop to the database on his work. I have never tryed to
    > transfer data from one database to another, but how can it be done ?
    > And if so, can it be done in a simple way, so he can do it by him self
    > ?
    >
    >
    >
    > My PhotoGallery
    > www.photo.activewebsite.dk
    >
     

Share This Page