Maximum number of fields

[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

 

[Rick Brandt]

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?

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.

 

[John Vinson]

Hi,

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

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?

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.