Does anyone know why I would get an error in my access
database when I try to add a column, "TOO MANY FIELDS
DEFINED"???
There is a limit of 255 fields in any table - and changing the
definition of a field 'uses up' one of these slots. If you have been
making lots of changes to field definitions, you can use Tools...
Database Utilities... Compact to recover the "lost" entries.
If you are trying to create a table with 255 or more fields - stop!
I've needed as many as sixty fields, twice in the past twenty years of
relational database design. I cannot imagine a properly normalized
table with that many fields.
John W. Vinson[MVP]
(no longer chatting for now)
