"Too many fields defined" error, but don't have 255 fields

D

daisyd65

I'm receiving a "too many fields defined" error when I try to save my table
design, but I have nowhere near 255 fields. I don't want to have to do all
the work over again. Is there any way around this problem? All my fields are
only 1 and 2 character length text fields, with only one indexed field.
 
D

Duane Hookom

As you create and delete or rename fields, your field count goes up. You
could try compact your database to release the field count to the actual
number of fields.

It seems that you might be creating a much un-normalized table. Most of us
old-timers suggest that if you have more than about 30 fields, there is
something wrong with your structure. Your requirements might call for more
fields but this should be very rare.
 
Top