Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

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

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page