Too many fields defined

[Luis]

Hello.
I'm building a script that adds fields in a table if they are not defined yet.
Every field is of VARCHAR(10) datatype.

The problem i'm having is that i'm getting this "Too many fields defined"
error and there are only about 90 fields on the table.

Thanks

Luis

 

[John Spencer]

Try compacting the database.

You are allowed a maximum of 255 fields in a table, but when you add a field
or modify a field Access uses one of the 255 field slots. If you delete the
field, the slot is still used up. When you compact the database, the number
of slots used is reset to the number of fields in the table.

That said, adding 90 fields to a table usually indicates a design problem.
Very rarely do tables exceed 20 fields in well-designed databases. I will
admit there are instances where many more fields are needed, but it is almost
always the case that a design change is needed.

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

 

[Luis]

Compacting the database solved the problem.
I usually don't use this number of fields, but i'm building a parser to .txt
files that is going to be used by a telecommunications company owned by the
company where i work that is in another country.

The .txt files has more or less than 5 million records, so you can see that
there is a hard task. I already divide the output tables to 2.

Thanks.