2 Replies Latest reply on Jul 21, 2012 9:48 PM by TuxfordC

    Archiving Records



      Archiving Records


       Is the following proposal a sensible/logical way for archiving income/tax records?

       The income data needs to be kept for a minimum of ten years, and preferably kept small.  I'm thinking about having a separate table for each

      financial year, identical structures with no more than six fields, Tables identified by including Year date in the name. Data recording change to the

      next table to be controlled automatically by the date.  Completed tables to be exported for archive and deleted from the programme.  

      Okay, or is the idea stupid?



        • 1. Re: Archiving Records

          Separate tables for each table will be very problematic. For each new table you also have to create new layouts and any needed relationships to work with it. You'll have to modify your database design in all these areas with each added year. It will also make it difficult for any reports/analysis that needs to span more than one year.

          It will make more sense to keep all of this in one table, but use a field in the table to identify the year.

          • 2. Re: Archiving Records

            Thanks Phil.

                               Idea is abandoned.