Welcome to SPN

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

Sign Up Now!

How to archive fields in Access?

Discussion in 'Information Technology' started by GER farming, Jul 28, 2006.

  1. GER farming

    GER farming
    Expand Collapse
    Guest

    We keep a database of our cows in Access. With changes in legislation
    concerning farming we now have 10 or more fields that we no longer require,
    but do not want to delete them and the information in them. Can I archive
    the fields similar to archiving records in order to make the database a bit
    less unwieldy.
     
  2. Loading...

    Similar Threads Forum Date
    Ghadar Party Martyrs Memorial (Photo Archive) History of Sikhism Mar 26, 2011
    Heritage Four Centuries in its corners (National Archives India & Slideshow) History of Sikhism Aug 27, 2010
    The Tomes Of The Khalsa Part III: The Doctrine Of Utter Dread (from Sikh Archives) Interfaith Dialogues Aug 15, 2010
    Sikh busmen win battle to wear turbans (31 Years Ago, The Guardian Archives) Sikh Sikhi Sikhism Jul 1, 2010
    Hinduism The Sai Baba Scamster (from Sikh Archives) Interfaith Dialogues Jun 26, 2010

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 16 Jun 2006 05:46:02 -0700, GER farming <GER
    farming@discussions.microsoft.com> wrote:

    >We keep a database of our cows in Access. With changes in legislation
    >concerning farming we now have 10 or more fields that we no longer require,
    >but do not want to delete them and the information in them. Can I archive
    >the fields similar to archiving records in order to make the database a bit
    >less unwieldy.


    Not really, other than by creating a new table with a narrower table.

    You can use a Query selecting all but these ten fields, and use this
    Query; or you can use data entry/editing Forms that simply don't have
    controls for these fields. You shouldn't be looking at table
    datasheets anyway.

    John W. Vinson[MVP]
     

Share This Page