[AccessD] Maximum number of columns in a table ?

Francisco,

right now we have column fields 2m(onths) 3, 4-6, 7-12, >2y (years which
is 13 - 24) and <2y (goes up to 30 years)) Now they want a field for each
individual monts; I think that creating a table with roughtly 70 fields
would be the most painless solution (and from it a query with original
fields - 4-6, 7-12, and reling it as datasource for reports)

> Oleg,
>    70 fields? I recommend reviewing the benefits of normalization,
> specifically BCNF which is a derived from 3NF
> http://databasejournal.com/sqletc/article.php/1443021
>
> more hits on google:
> http://tinyurl.com/5g4v
>
> -Francisco
> http://rcm.netfirms.com
> ----- Original Message -----
> From: "Drew Wutka" <DWUTKA at marlow.com>
> To: <accessd at databaseadvisors.com>
> Sent: Wednesday, February 05, 2003 3:47 PM
> Subject: RE: [AccessD] Maximum number of columns in a table ?
>
>
> : I believe the number of fields in a table is 255....I am assuming it's
> the : same for a query.
> :
> : Drew
> :
> : -----Original Message-----
> : From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
> : Sent: Wednesday, February 05, 2003 1:44 PM
> : To: accessd at databaseadvisors.com
> : Subject: [AccessD] Maximum number of columns in a table ?
> :
> :
> : I need to feet around 70, can I ? I found this on google, but somehowi
> : don't trust it; o limit on rows ??
> : ------------------------------------
> :
> : Maximum number of rows per table No Limit
> :
> : Maximum number of tables per database No limit
> :
> : Maximum number of tablespaces per database 32767
> :
> : Maximum number of devices 32767
> :
> : Maximum storage capacity 70 TB
> :
> : Maximum row size (excluding BLOB & FO columns) 3992 bytes
> :
> : Maximum number of columns per table 252
> :
> : Maximum number of columns per index 16
> :
> : Maximum number of journal files per database 8
> :
> : Maximum length of table/column name 18 bytes
> :
> : Maximum number of tables per join 31
> :
> : Maximum number of savepoints per transaction 32
> :
> : Maximum cache memory 2GB
> :
> :
> :
> : -----------------------------------------
> : Send a Xuppa Valentine to Your Sweetheart today!
> : http://www.xuppa.com/greet/
> :
> :
> : _______________________________________________
> : AccessD mailing list
> : AccessD at databaseadvisors.com
> : http://databaseadvisors.com/mailman/listinfo/accessd
> : Website: http://www.databaseadvisors.com
> : _______________________________________________
> : AccessD mailing list
> : AccessD at databaseadvisors.com
> : http://databaseadvisors.com/mailman/listinfo/accessd
> : Website: http://www.databaseadvisors.com
> :
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Send a Xuppa Valentine to Your Sweetheart today!
http://www.xuppa.com/greet/