Welcome to SPN

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

Sign Up Now!

Migrating From Access

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

  1. JK

    JK
    Expand Collapse
    Guest

    We have an Access application that is working well but we would like it
    to work better. Here's the situation:

    We have users in the States and overseas who all want to connect to the
    same database. Some of these users (especially the ones overseas) want
    to be able to go into the field where there is no internet access and
    take both the data, and the functionality of the database with them.

    The way we work it right now is that people overseas download the
    frontend and backend of an Access database, then once a week, the
    different teams upload their new data (their backends) to our server
    and we run some scripts to combine all the data. We then send out the
    "combined" backend for all to download so that everyone has everyone's
    information. When we develop a new version of the frontend, we push
    that out for all to download.

    Question: Does anyone know of a web or application based solution that
    can allow us to manage one database on a server, yet allow users to
    download all data to their HDD, so that they can work offline? The
    only requirement would be auto-syncing when a connection is
    reestablished. Other than that, we are open to anything. Web-based or
    app-based frontend, pretty much any type of db on the backend - the key
    is the working offline.

    Any suggestions/advice/enlightenment would be appreciated.

    Thanks!
    JK
     
  2. Loading...


  3. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    Access can do it. Search Help or Google on "Replication".
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "JK" wrote:

    > We have an Access application that is working well but we would like it
    > to work better. Here's the situation:
    >
    > We have users in the States and overseas who all want to connect to the
    > same database. Some of these users (especially the ones overseas) want
    > to be able to go into the field where there is no internet access and
    > take both the data, and the functionality of the database with them.
    >
    > The way we work it right now is that people overseas download the
    > frontend and backend of an Access database, then once a week, the
    > different teams upload their new data (their backends) to our server
    > and we run some scripts to combine all the data. We then send out the
    > "combined" backend for all to download so that everyone has everyone's
    > information. When we develop a new version of the frontend, we push
    > that out for all to download.
    >
    > Question: Does anyone know of a web or application based solution that
    > can allow us to manage one database on a server, yet allow users to
    > download all data to their HDD, so that they can work offline? The
    > only requirement would be auto-syncing when a connection is
    > reestablished. Other than that, we are open to anything. Web-based or
    > app-based frontend, pretty much any type of db on the backend - the key
    > is the working offline.
    >
    > Any suggestions/advice/enlightenment would be appreciated.
    >
    > Thanks!
    > JK
    >
    >
     

Share This Page