Access gives "too many fields defined" when I try to change field

B

Beto

I am trying to change a field format from yes/no to text. When I try to save
the table, I get the message "Too many fields defined" and not allowed to
save the change.
 
D

Douglas J Steele

When you change a field, Access adds a new field of the new type, transfers
data from the old field to the new field, then deletes the old field.
There's a 255 field limit for tables, but Access doesn't usually reset the
count unless you compact the database.
 
Top