Too many fields

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
 
C

Charles

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
 
T

Tim Ferguson

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

"Property value is too large." 2
35 fields 5
Too many fields? 7
Autonumber records inserted in gaps 1
Max Field limit 4
Table Design with Many Fields 6
Limit on number of fields in MS Access forms 3
Can't Save Changes to a Table (Access 2000) 1

Top