Access 2007 specifications state that there can be 255 fields in a Table. I am trying to create a Table with 163 fields. When I try to save the Table I get a message that I have too many fields.
What is my problem?
Novice
Windows 7 64bit 
Access 2010 64bit
Access 2007 specifications state that there can be 255 fields in a Table. I am trying to create a Table with 163 fields. When I try to save the Table I get a message that I have too many fields.
What is my problem?
Master of Nothing
Windows 2K Access 2000
It's actually 255 fields over the lifetime of the table. So if you create a table with 250 fields, then delete 200, the most fields you can add is 5.Originally Posted by Merv
To fix this, import the table into a new MDB. The new (old) table will then have a limit of 205 fields that can be added (255 minus the 50 old fields).
Competent Performer
Windows XP Access 2007
You may be hitting a problem with indexing. I believe that an index counts as a field in these circumstances (I stand to be proved wrong on this however).
More worrying is your database set up. A 163 field table screams out to me that you have not normalised your data properly.
MS-Access Developer
Windows 7 64bit Access 2010 64bit
I am wonder for a Table with 163 fieldsthis leads me to bad normalization of data and a BIG mess with data integrity and indexing.
Combine two fields, Null fields involved
Table fields which depend on other fields
Posting Permissions
Reply With Quote