2003 .mdbs: Are ~75 fields too many?

J

Jim Shores

Hi,
I am writing some code and wonder, would, say, 75 fields by a few thousand rows be a problem for the software.
 
D

Dirk Goldgar

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