How to reset number of fields in a table
Posted on 2014-03-28
I remove some fields in a table and replace them with others periodically. Apparently Access doesn't reset the total number of fields as they are removed, and continues to accumulate the count, which leads to an error when the table is referenced.
I've seen a possible fix being to copy the table with a different name, delete the original, then name the copy with the original name.
This didn't seem to work.
I have about 90 fields, and I believe the limit is 255.
1. How do I "see" how many fields Access thinks this table has, and
2. how do I resent the count?