Welcome to SPN

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

Sign Up Now!

Possible to archive tables in Access with Date/Time stamp?

Discussion in 'Information Technology' started by Ed, Nov 11, 2005.

  1. Ed

    Ed
    Expand Collapse
    Guest

    I import data to Access each day but would like to archive the previous day's
    data and the corresponding table with the appropriate date. Is this possible?

    If yes, how would this be coded, or better yet, run through a simple macro?

    Thanks,

    Ed
     
  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. Rick B

    Rick B
    Expand Collapse
    Guest

    You can, but typically shouldn't. If you store the date in the record, then
    just keep everything in that one table. When you run reports queries or
    forms, then you can filter your records by that date. It is rarely a good
    idea to create identical tables with a date in the name of the table. How
    will you ever go back and run historical or combined reports?

    Just store the date with each record.

    Now, in some cases, you may want to go back and purge very old data. Maybe
    run a delete query once a year or once a month to delete old records. Of
    course, you could make a backup copy before doing the deletes.


    --
    Rick B



    "Ed" <Ed@discussions.microsoft.com> wrote in message
    news:075372E0-7D13-4738-9E58-2736DBC98B5A@microsoft.com...
    >I import data to Access each day but would like to archive the previous
    >day's
    > data and the corresponding table with the appropriate date. Is this
    > possible?
    >
    > If yes, how would this be coded, or better yet, run through a simple
    > macro?
    >
    > Thanks,
    >
    > Ed
     

Share This Page