Welcome to SPN

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

Sign Up Now!

Maintaining live access installation

Discussion in 'Information Technology' started by Bobk, Nov 10, 2005.

  1. Bobk

    Bobk
    Expand Collapse
    Guest

    What is the best way to update a live Access installation? I installed Access
    in a shop floor environment where data is being gathered in real time. A
    substantial amount of data has been gathered and is being used daily. I now
    want to add more forms, queries and reports, but don't want to lose the
    existing data. What is the best way to accomplish this?
     
  2. Loading...

    Similar Threads Forum Date
    India Sikhs themselves should first start maintaining dignity of turban Breaking News Aug 8, 2013
    India Maintaining peace in Punjab, our responsibility: Damdami Taksal chief Breaking News Jun 14, 2012
    Maintaining relations or communion Sikh Rehat Maryada Dec 29, 2010
    maintaining our culture Interfaith Dialogues Oct 27, 2007
    Sikh News California Lawyer To Deliver Sikh Prayer At GOP Convention Breaking News Jul 20, 2016

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    The application should be split into a front-end (containing the queries,
    forms, reports, macros and modules), linked to a back-end (containing the
    tables).

    Assuming this is a shared database, only the back-end should exist on the
    server: each user should have his/her own copy of the front-end, preferably
    on their hard drive.

    Even if it's a single-user application, it should still be split, since then
    you can change the functionality of the application at any time, without
    impacting the data.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Bobk" <Bobk@discussions.microsoft.com> wrote in message
    news:46E9B16C-8A6E-492F-A1BE-7966ED920109@microsoft.com...
    > What is the best way to update a live Access installation? I installed

    Access
    > in a shop floor environment where data is being gathered in real time. A
    > substantial amount of data has been gathered and is being used daily. I

    now
    > want to add more forms, queries and reports, but don't want to lose the
    > existing data. What is the best way to accomplish this?
     
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

  5. Bobk

    Bobk
    Expand Collapse
    Guest

    Thanks for the help.

    "Douglas J Steele" wrote:

    > The application should be split into a front-end (containing the queries,
    > forms, reports, macros and modules), linked to a back-end (containing the
    > tables).
    >
    > Assuming this is a shared database, only the back-end should exist on the
    > server: each user should have his/her own copy of the front-end, preferably
    > on their hard drive.
    >
    > Even if it's a single-user application, it should still be split, since then
    > you can change the functionality of the application at any time, without
    > impacting the data.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Bobk" <Bobk@discussions.microsoft.com> wrote in message
    > news:46E9B16C-8A6E-492F-A1BE-7966ED920109@microsoft.com...
    > > What is the best way to update a live Access installation? I installed

    > Access
    > > in a shop floor environment where data is being gathered in real time. A
    > > substantial amount of data has been gathered and is being used daily. I

    > now
    > > want to add more forms, queries and reports, but don't want to lose the
    > > existing data. What is the best way to accomplish this?

    >
    >
    >
     
  6. Bobk

    Bobk
    Expand Collapse
    Guest

  7. lingram

    lingram
    Expand Collapse
    Guest

    You should create a two-tier solution. Create a new empty database (front
    end) and import everything but the tables from your existing one. Then use
    linked table manager to link to the tables in the original .mdb file. Then
    you can replace the front end with new versions at will. You will only need
    to change the back end when changes /additions to tables are necessary. The
    original file (now the badk end) should eventually have all the
    forms/queries/modules cleaned out. Use'rs should open the front end of the
    database not the back end.

    "Bobk" wrote:

    > What is the best way to update a live Access installation? I installed Access
    > in a shop floor environment where data is being gathered in real time. A
    > substantial amount of data has been gathered and is being used daily. I now
    > want to add more forms, queries and reports, but don't want to lose the
    > existing data. What is the best way to accomplish this?
     

Share This Page