Too many fields error message

[beetlebailey62]

I am setting up a new table with many fields. I thought the limit was 255,
but I only have 100. I am getting too many fields error message and it will
not allow me to enter any more.

Any thoughts?

 

[John Spencer]

PROBABLY you have been adding and deleting or redifining existing
fields. Every time you do you use one of the 255 slots.

Good news is that you can compact your database and recapture the used
(but empty) slots.

Bad news is that there is almost never a need to have 100 (not to
mention 255) fields in a correctly designed relational database. So you
probably need to redesign your structure.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Jeff Boyce]

I agree with John's assessment.

There's a good chance that you have a ... spreadsheet, rather than a
well-normalized relational database table.

If you'll provide a bit more specific description of what you are trying to
put in all those fields, folks here may be able to offer more specific
suggestions on ways that will allow you to use the relationally-oriented
features and functions that Access offers.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/