Too many fields defined.

  • Thread starter Thread starter SteveD
  • Start date Start date
S

SteveD

I have built a table that has about 230+ columns. When I
try to change the attributes of a column from text to
number (and save the file) I get an error "Too many fields
defined". When I display the table, it is showing that I
still have 17 more colums available.

What am I doing wrong?
 
Hi SteveD,

You need to compact the database to "reset" the thing that keeps track
of the number of columns.

However, if you have that many columns in your table there's almost
certainly something radically wrong with your design, and you'll be
better off in the long run if you split your data into several, much
narrower, related tables.
 
Back
Top