Col Limit in a table

[SITCFanTN]

What is the maximum number of columns I can safely have in a single table in
Access 2003?

Thank you

 

[Roger Carlson]

255. This and other interesting limits of Access can be found in the Help
system under "Specifications"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Allen Browne]

255

(It's in Help, under Access specifications.)

 

[Jerry Whittle]

As Roger and Allen have correctly noted, the maximum limit is 255; however,
you probably can't, nor should, have anywhere near that many.

There's another limit to contend with and that's 2000 characters per record
(excluding Memo, OLE and Attachments). That's only about 8 characters per
field on average.

Also properly normalized data seldom requires over 30 fields per table. The
data may need multiple tables though which are linked to each other.