{Access} Too many fields defined
tiboge
-
Pierre -
Pierre -
Hello,
After adding a new column to my database and giving it a "data type" of yes or no, I receive the message: Too many fields defined, Error 3190, You attempted an operation involving more than 255 fields. Reduce the number of fields and try again. Even when I delete the new column, I still get the same message and I am still unable to add new columns. My database does not exceed 90 columns or fields, so why am I being told I tried an operation involving more than 255 fields? How can I unlock this.
After adding a new column to my database and giving it a "data type" of yes or no, I receive the message: Too many fields defined, Error 3190, You attempted an operation involving more than 255 fields. Reduce the number of fields and try again. Even when I delete the new column, I still get the same message and I am still unable to add new columns. My database does not exceed 90 columns or fields, so why am I being told I tried an operation involving more than 255 fields? How can I unlock this.
Configuration: Windows XP Internet Explorer 7.0
2 answers
The topic isn’t new, but I wanted to share the solution I myself had trouble finding!
It should be noted that every time you create or modify a field (even just its property), Microsoft Access increments an internal counter, and even deleting the field does not decrease the counter.
It is therefore necessary to “compact” your database from the “Manage” section of the System Menu in Access 2007 or from the “Tools” menu in Access 2003 to reset this counter.
Best regards.
It should be noted that every time you create or modify a field (even just its property), Microsoft Access increments an internal counter, and even deleting the field does not decrease the counter.
It is therefore necessary to “compact” your database from the “Manage” section of the System Menu in Access 2007 or from the “Tools” menu in Access 2003 to reset this counter.
Best regards.
hdt
Excellent answer
Pierre
Very useful
try this:
1) copy your table, without the data. you will therefore have an identical but empty table.
2) delete the fields you don’t need.
3) export table 1 to table 2 (copy table) with the fields you need.
This is indeed a "limit" of Access because the number of fields is limited to 255.
That said, for ten years I’ve been designing databases and I’ve rarely exceeded 50 fields ... You should check your relationships between your tables ;-)
1) copy your table, without the data. you will therefore have an identical but empty table.
2) delete the fields you don’t need.
3) export table 1 to table 2 (copy table) with the fields you need.
This is indeed a "limit" of Access because the number of fields is limited to 255.
That said, for ten years I’ve been designing databases and I’ve rarely exceeded 50 fields ... You should check your relationships between your tables ;-)