Too many fields

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

I have built a database table, but when I go to save it,
an error message says "Too many fields". How many fields
can I put into a table? Thanks
 
If you have "too many fields", try splitting your table in
two, use (or create) a common/key field and run queries
joined on the common/key field. Even 200 fields is
usually too many to manipulate.

Hope this helps
 
If you have "too many fields", try splitting your table in
two, use (or create) a common/key field and run queries
joined on the common/key field. Even 200 fields is
usually too many to manipulate.
Click to expand...
Well, kind of; but the point is not to chop this spreadsheet in two, but to
remove all the repeated and dependent fields into their own multiple
tables. This is the process known as normalisation, and usually results in
tables with fewer than twenty fields -- it's extremely rare to go over
thirty.

B wishes


Tim F
 

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

35 fields 5
"Property value is too large." 2
Autonumber records inserted in gaps 1
Too many fields? 7
Max Field limit 4
Form Design 9
Table Design with Many Fields 6
Limit on number of fields in MS Access forms 3

Back
Top