When I try to insert a new column in a database i've created I get the error
'Too many fields defined'. Can anyone help?
A Table is limited to an (absurdly enormous) 255 fields... but every
time you change the design of a field, one slot gets used up. Tools...
Database Utilities... Compact and Repair will recover these used up
slots.
If you're over 30 fields, STOP. "Fields are expensive, records are
cheap" - you almost certainly have some one-to-many relationships
embedded in each record, which would be much better modeled as two
tables in a one to many relationship. If you're storing data (days of
the week, names, products, etc.) in fieldnames then you certainly need
to restructure your table!
John W. Vinson[MVP]
