Maximum number of fields

  • Thread starter Thread starter Tan SH
  • Start date Start date
T

Tan SH

Hi,

What is the maximum number of fields allowed for Access 97
and Access 2000?

What if I need more fields than the maximum allowed? Is
there a way I can easily split a table but still have them
referred to as one table?

br/Tan
 
Tan SH said:
Hi,

What is the maximum number of fields allowed for Access 97
and Access 2000?

What if I need more fields than the maximum allowed? Is
there a way I can easily split a table but still have them
referred to as one table?
Click to expand...

The maximum is 255, but anything approaching even half of that almost always
indicates an improper design. If you describe your table structure, I'm sure you'll
get lots of advice on how to reorganize the data into multiple narrower tables.
 
Hi,

What is the maximum number of fields allowed for Access 97
and Access 2000?
Click to expand...

255, in both - about five times as many as any rational table will
ever need.
What if I need more fields than the maximum allowed? Is
there a way I can easily split a table but still have them
referred to as one table?
Click to expand...

If you can describe any Entity with 255 atomic, nonrepeating, mutually
independent attributes, my hat's off to you. The need for such a wide
table VERY strongly suggests that you have a one-to-many relationship
embedded within each record, and that you should split it into two
tables - but NOT two wide-flat tables; instead of 255 *fields* you
would add 255 *records* to a tall, thin table.
 
Back
Top