Max # of columns and record length

In access xp, or 2000, How many columns are allowed in 1 table,
And in this talbe with the max number of columns, what is the largest record length possible. (Sum of fields types lengths)
LVL 14
adwisemanAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
to be exact

Microsoft Access database specifications
Access database

Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

Table

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number may be less because of tables opened internally by Microsoft Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255
0
 
Rey Obrero (Capricorn1)Commented:
255 Columns or fields
0
 
walterecookCommented:
Well done Rey.
I would caution you, adwiseman, that before you build a table of 255 columns, SERIOUSLY consider if that table HAS to be that wide.  You may be better off normalizing where you can.  I only say this because it's pretty rare to even approach 100 columns.

Walt
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
adwisemanAuthor Commented:
I'm not actualy doing this, it was just an outer-boundry question.  

Great stuff  capricorn1
0
 
david251Commented:
I was able to get 778147 Characters in in 12 memo fiels before access started to complain.

-David251
0
 
calculus87Commented:
I actually would like there to be more than just 255 Columns or fields, because at work I use well of three hundred in some cases.  So I have to have 2 database open and blah it is a pain.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.