Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page