How many fields are allowed on an Access 2002 table?

  • Thread starter Thread starter Guest
  • Start date Start date
255.

That's 3 or 4 times what you could ever need in any normalized table.
 
I can't get to even 140 with ut an error that says I have too many fields
identified.
 
If 255 fields are allowed why do I recieve "Too Many Fields " when I reach
100 to 140.
 
If I tell you how to create more fields, would you promise to read up on
normalization?
http://www.ltcomputerdesigns.com/JCReferences.html#DatabaseDesign101

You may have defined and then deleted some fields. You might want to try
compact and repair your database and then Access should allow you to add
more fields. As suggested by Allen and me, anything over about 50 fields is
suspect for normalization issues.
 
If you rename a field and/or delete a field, one of those
255 "spots" is used up. I believe compacting the database
will reset that number, but I'm not 100% sure.

Still, 140 fields seems to be about 100 too many.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:
 
Jeff said:
If you rename a field and/or delete a field, one of those
255 "spots" is used up. I believe compacting the database
will reset that number, but I'm not 100% sure.

Still, 140 fields seems to be about 100 too many.
Click to expand...

There is also a limit to the total bytes per row (2K I think) that you can hit
before the field quantity limit (the error is the same).
 
After deleting fields, you may need to compact the database before they
become available again:
Tools | Database Utilities | Compact

Please do follow through on the link Duane gave you, or search
"normalization" to find more links for yourself.

The issue Rick raised about the entire record not being more than about 2k
characters wide is the more practical limitation.
 
Everyaone who responded:

Thanks for the information and advice. when you'r just learining this stuff
I found the manuals don't tell all.

Darrell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table validation rule - allow only one occurence in a field 2
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
35 fields 5
Table Design with Many Fields 6
Limit on number of fields in MS Access forms 3
Multiple Many-to-Many relationships 8
Assistance with Many-to-Many Relationships 4
unique index still allow duplicates when date fields are null 2

Back
Top