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
 
Back
Top