Is there a limit to the number of fields to a table??

[SheaLee]

My boss has a table with tons of fields on it, he designed it this way because it was easier to add data to one place, but now the table keeps crashing, does ms 2k have a limit to the number of fields in a table??
Thanks in advance.

 

[RuralGuy]

Yes! Look in Access Help (not VBA Help) under Specifications. My acXP is limited to 255 fields in a record.

 

[SheaLee]

Okay will do thanks again

wow you are up late....go to bed sleepy head

 

[RuralGuy]

It is only 7:42 PM here in the Rockies! The sun hasn't even set completely yet.