Re: to many fields are defined

This was answered in your OTHER post. One post per question please.

If you are in a table when this happens, how many fields do you have? You
should have no more than 20 or 30 fields in any given table. A
well-designed database table will most likely contain only 10 or 15 fields.

What is the structure of this table? What type of data are you trying to
store?

--
Rick B



"yorkielover02" <yorkielover02@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36E211B7-D394-45CD-A6D9-CC4DAFF4847A@xxxxxxxxxxxxxxxx
>I am trying to add colums and it says that to many fields are defined. I
> tried taking a few out to make room but it stills says to many fields are
> defined.


.

Relevant Pages

  • Re: To many fields defined
    ... this point there's a very good chance your table is not properly normalized. ... >I am trying to add colums and it says that to many fields are defined. ... > tried taking a few out to make room but it stills says to many fields are ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Prime numbers
    ... can always produce a composite (non-prime) number that has different ... divisors... ... Rick ... Prev by Date: ...
    (comp.lang.basic.visual.misc)
  • Re: Buttons / ForeColor Property
    ... The first one is an API method of doing this and the second one is a kludge that works very nicely... ... Rick - MVP ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: Beginner question
    ... However, you should use the Stop statement only while debugging, because it does not free references to objects." ... Rick - MVP ... Prev by Date: ...
    (comp.lang.basic.visual.misc)
  • Re: add new line to task body
    ... A task in Outlook? ... We (mainly Rick) are really working in the dark here. ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)