number of fields limit in access 2000 ???

[1712]

I have not found a limit to # of fields to access 2000. I know it is not good practice to create too many fields for a table but I simply have around 300 fields that are just for collection purposes and want to know if there is a limit.

 

[PaulF]

255 per the XP help files

Access specifications
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

PaulF

 

[MichaelRed]

300 seems like a lot regardless of the fact of the limit. Also, realize that the 'limit' - while it says Tables/fields actually means Recordset fields and 'objects' which loosely translates to jopins, indicies and (I think) additional fields within jpinns and indices, so a "table" with 255 fields can only ever be addressed as a single entity.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places