Too many fields defined

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to insert a new column in a database i've created I get the error
'Too many fields defined'. Can anyone help?
 
When I try to insert a new column in a database i've created I get the error
'Too many fields defined'. Can anyone help?
Click to expand...

A Table is limited to an (absurdly enormous) 255 fields... but every
time you change the design of a field, one slot gets used up. Tools...
Database Utilities... Compact and Repair will recover these used up
slots.

If you're over 30 fields, STOP. "Fields are expensive, records are
cheap" - you almost certainly have some one-to-many relationships
embedded in each record, which would be much better modeled as two
tables in a one to many relationship. If you're storing data (days of
the week, names, products, etc.) in fieldnames then you certainly need
to restructure your table!

John W. Vinson[MVP]
 

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 Error 1
Too many fields 3
"too many fields defined" error 24
what does "too many fields defined" mean? 8
Access 2003 field errors 3
export crosstab query too many fields error 1
Too many fields detailed 2
Too many fields define when running a report 5

Back
Top