changing table values

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

When attempting to change data types, or even field sizes
in my base table, I get the message "too many fields
defined" and it does not allow the changes to be made.
How can I correct the problem so that I can change the
table values. Thanks!
 
1) Tools>DatabaseUtilities>CompactAndRepair

2) Try making your changes again.
--------------

I am assuming you are running into the 255 field limit. Even if you don't
seem to be using anywhere near 255 fields, Access may think you are. Every
time you change a Field type, Access creates a new field of the new type,
copies the old data into it and "deletes" the old field. And when either you
or Access "deletes" a field, it still takes up space (and counts against the
255 field limit) until you do a CompactAndRepair. CompactAndRepair cleans
up everything: it frees up unused space and resets internal counters, etc.

On the other hand, if you actually do have 255 fields in a single table, you
have hit a wall. I'd suggest a serious rethink of your database design.
 
Back
Top