Welcome to SPN

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

Sign Up Now!

What Does "too Many Fields Defined" Mean?

Discussion in 'Information Technology' started by Plumbers&Pipefitters, Nov 2, 2005.

  1. Plumbers&Pipefitters

    Plumbers&Pipefitters
    Expand Collapse
    Guest

    I tried to add a new column to my database, but when I clicked on "column" to
    add, a message popped up saying "Too many fields defined," and the help
    buttlon next to the message opened to a blank screen. Can anyone help??
     
  2. Loading...

    Similar Threads Forum Date
    Does Life Ever Feel Completely Pointless And Meaningless? Questions and Answers May 15, 2017
    Why Does The Woman Walk Behind The Man In A Sikh Wedding? Questions and Answers Apr 20, 2017
    What Does The Sikh Turban Mean? Hard Talk Mar 4, 2017
    Original Karam And Reciprocal Karam . How Does One Know ? Sikh Sikhi Sikhism Jan 22, 2017
    Tee Sadhya Kaay Kartey ( What Does She Do Now ? ) Theatre, Movies & Cinema Jan 17, 2017

  3. OP
    Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Plumbers&Pipefitters wrote:
    >I tried to add a new column to my database, but when I clicked on
    > "column" to add, a message popped up saying "Too many fields
    > defined," and the help buttlon next to the message opened to a blank
    > screen. Can anyone help??


    It means you almost certainly are using Access like a spreadsheet.
    Access has a limit of 255 fields. I have never seen a properly designed
    database with over 50 fields.

    The usual problem is normalization. I would guess you have something
    like a record for each person and are keeping a record of their name address
    phone etc and also listing all the classes they are taking or jobs they have
    worked on.

    Proper design requires one table for each person, another table for the
    classes they take and other for the jobs they have worked on with a new
    record, not a new field for each new class or job. Keep the address and
    phone information with the individual table.

    When designed right, not only can you have thousands of events connected
    to an individual, but it will also run faster and you can access the
    information in more ways.

    If this is confusing and it usually is the first time or even the second
    or third time though it, describe what you are doing in more detail and we
    will try and aim you in the right direction.



    --
    Joseph Meehan

    Dia duit
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page