G
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
George Nicholson
Tools>DatabaseUtilities>Compact
This will "reset" the field counter so that any fields you may have deleted
don't count against the 255 field limit. Changing a field's datatype creates
a new field and deletes the old one behind the scenes, which can also counts
against the limit until you compact.
If you still get the error after compacting, rethink your database design so
that you don't run up against Access' (perfectly reasonable) 255
fields-per-table limit.
This will "reset" the field counter so that any fields you may have deleted
don't count against the 255 field limit. Changing a field's datatype creates
a new field and deletes the old one behind the scenes, which can also counts
against the limit until you compact.
If you still get the error after compacting, rethink your database design so
that you don't run up against Access' (perfectly reasonable) 255
fields-per-table limit.
R
Rick B
Yes.
J
John Vinson
Yes.
Rick, that was unkind. If all you're going to do is make sarcastic
posts like this, please let your fingers take a rest instead.
John W. Vinson[MVP]