"Too many fields defined" error, but don't have 255 fields

D

daisyd65

I'm receiving a "too many fields defined" error when I try to save my table
design, but I have nowhere near 255 fields. I don't want to have to do all
the work over again. Is there any way around this problem? All my fields are
only 1 and 2 character length text fields, with only one indexed field.
 
D

Duane Hookom

As you create and delete or rename fields, your field count goes up. You
could try compact your database to release the field count to the actual
number of fields.

It seems that you might be creating a much un-normalized table. Most of us
old-timers suggest that if you have more than about 30 fields, there is
something wrong with your structure. Your requirements might call for more
fields but this should be very rare.
 

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

Top