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 Reading Baani Magically Affect Our Body And Psyche? And Does The Effect Depend On The Bani Read Intellectual Translations by SPNers Apr 30, 2016
    Does God Care What You Wear? Gurmat Vichaar Apr 23, 2016
    Hard Talk Does Amrit Erase All Sins? Hard Talk Apr 1, 2016
    What Believing In God Does To Your Brain Interfaith Dialogues Mar 26, 2016
    Interfaith I Have More Sikhs In My Cabinet Than Modi Does - Trudeau Interfaith Dialogues Mar 12, 2016

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

Share This Page