Too many fields defined.

[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?

 

[SteveD]

I found my problem. It is under the Tools tab, Database
Utilities, Compact and Repair Database. There is a
problem with the column counter that is fixed by running
the Compact & Repair DB option.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;198504&Product=acc2000

 

[John Nurick]

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.