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

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
     
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