max no fields allowed in a table

[rb2006]

using access 2000+
anyone know if there is a limit to the number of fields that
are allowed in a table
I have currently got up to 150 but may need to go up to 300+
Most of these are number fields

 

[Ron_dK]

Have a look at this :

http://www.micronetservices.com/Access2kCapacities.htm

 

[Groundrush]

Nice find

 

[neileg]

Even 150 fields suggests your design is not normalised. In general tables should be long and narrow, not short and wide.

 

[The_Doc_Man]

I have found that almost invariably, when you have tables with too many fields, it is because you translated the tables from a spreadsheet. Which means your design retains "flat-file" thinking. Step away from the keyboard. Turn off the monitor. Keep your hands where we can see them... this is the Access Police....

Seriously, you are asking for a LOT of trouble. I very strongly urge you to read up on "Normalization" as a way to find out why and how you should change your structures.

 

[boblarson]

I love normalization, I love normalization ...

A BIG Amen to what Doc Man said. If you don't, you're only making it potentially harder on yourself, as well as anyone who might follow you.