Hitting premature limitation on number of table fields allowed

  • Thread starter Thread starter Meagan
  • Start date Start date
M

Meagan

I am creating a main table and am not yet at the maximim 255 fields allowed,
but I am still getting the message that I have hit the limit (I can tell
where the end is because there are no more rows at the bottom). How can I
stop this message so I can continue to save?
Also, if I do hit the limit, and I need to add more fields for the form,
what do I do? Thanks for any help.
 
Meagan,

to answer your question, try to compact and repair your database. If you
have been deleting or changing your field definitions, this is part of the
problem.

To help you down the road: it is highly unlikely that you are designing an
efficient database if you have that many fields in your table. It is
probable that your table can be broken down into smaller tables, with
relationships created between them. This process is called normalization,
and there are numerous resources available in print and on the internet to
assist you.

HTH,

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Meagan said:
I am creating a main table and am not yet at the maximim 255 fields allowed,
but I am still getting the message that I have hit the limit (I can tell
where the end is because there are no more rows at the bottom). How can I
stop this message so I can continue to save?
Also, if I do hit the limit, and I need to add more fields for the form,
what do I do? Thanks for any help.
Click to expand...

You will not be able to place all the fields on one table. There is no
exception to this.

If you have any fields that contain similar data, Monday, Tuesday,
Wednesday,... Sunday fields for example, then your table is designed wrong.
 
For situations where, for example, I have months of the year, I have one
table that contains only that information. On the form, I have a combo box
so that the month can be selected from that list. There may be more than one
question on the form that asks for month, and if so, the months will always
be selected from the month table.
 
MSEagan said:
For situations where, for example, I have months of the year, I have one
table that contains only that information. On the form, I have a combo box
so that the month can be selected from that list. There may be more than one
question on the form that asks for month, and if so, the months will always
be selected from the month table.
Click to expand...

In this case you have a table (Months) with one field (column) named Month
and each record (row) contains the name of a month.
This is correct.
You would also have one table named Questions with fields Question and maybe
choices and Answers

A third table would be students and a forth would be Tests
These would be used in a form with StudentID and a subform with the actual
quiz.

Now you are not limited to 250 questions on a quiz but can mke them suffer
;)
 
Back
Top