2003 .mdbs: Are ~75 fields too many?

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

Guest

Hi,
I am writing some code and wonder, would, say, 75 fields by a few thousand rows be a problem for the software.
 
Jim Shores said:
Hi,
I am writing some code and wonder, would, say, 75 fields by a few
thousand rows be a problem for the software.
Click to expand...

It would certainly be no problem. On the other hand, 75 fields is an
unusually large number of fields for a well-designed, properly
normalized table. Do make sure that you've properly analyzed the
entities that make up your "problem space" and not tried to represent
one-to-many relationships in a single table.
 
Back
Top