Is there any way to correct a "too many fields defined" error?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Yes.
Click to expand...

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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Many Fields Defined????? 11
How to subtract a number from a Mergefield? 0
'invalid control property' and 'too many fields defined' 4
too many fields defined 2
Too Many Fields Defined Error 1
Too many fields defined 2
Too many fields defined when opening a form 1
"Too many fields defined" issue 11

Back
Top