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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top