Urgent..Max Number of Fields in a Access 2000 Table?

[bnath001]

Hello,

Is there any limit on the Maximum number of fields that can exist in an MS Access 2000 Table?

thank You
nath

 

[mfulton]

255 If you open helper in Access 2000 and type in max number of fields in table, then select Microsoft Access Specification, you get lots of helpful info.

Michelle

 

[MichaelRed]

Actually, this varies by the release/version. The 255 applies to '95 (& I believe '97). It was lower in version 1.x and 2.x.

If this is a problem, you really need to be reading about database normalization. Relational databases tend toward the concept of "Deep" (many records with small amounts of information {Fields}) as opposed to "wide" (few records w/ LOTS of information {Fields}).

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over