Drew Wutka
DWUTKA at marlow.com
Wed Feb 5 17:48:00 CST 2003
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