Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2005
    Posts
    44

    Unanswered: Creating an archive of past records

    Hey guys

    Whats the best way to create an archive of records within an access database which are not longer active but still need to be held for future reference??????



  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by netherton
    Hey guys

    Whats the best way to create an archive of records within an access database which are not longer active but still need to be held for future reference??????


    Uh ... I create a history table and move the records there ... That is a history table for each type of record (payment, expense, timecard, etc ...)
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Another option is to use bits or business logic to pull "active" records instead of inactive records. Naturally this is only effective up to a certain volume...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by Teddy
    Another option is to use bits or business logic to pull "active" records instead of inactive records. Naturally this is only effective up to a certain volume...
    And you have to build it in as part of the design of the table(s) ... And you have to have biz logic to update records to inactive ...

    So either way ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Feb 2006
    Posts
    56
    or you could output the records set to inactive to a text file (and structure the file for easy import), thereby eliminating the need to store them in your database. If you want a code example let me know.

    Thanks,

    John

  6. #6
    Join Date
    Apr 2005
    Posts
    44
    My user wants to be able to view the records in case she needs to write a reference for a past staff member but she doesnt want those who have left to keep occuring in the active set.


    Thanks guys, ideas much appreciated!

  7. #7
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    How big of a database are you dealing with here?

    The first question I would be asking is whether or not creating a historical schema is warranted based on your requirements. If your user wants to be able to generate information using historical data then off-site backups are right out. Depending on the scope and scale of your project, you may just want to go with the business logic/bit method.

    Just because data is there doesn't mean it needs to be exposed to the user. On the same token, just because a user wants to view data historically doesn't mean it needs to be in a seperate database structure...
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •