How many fields are allowed on an Access 2002 table?

[Darrell]

How many fields are allowed on an Access table?

 

[Duane Hookom]

255 or about 220 too many.

 

[Allen Browne]

255.

That's 3 or 4 times what you could ever need in any normalized table.

 

[Darrell]

I can't get to even 140 with ut an error that says I have too many fields
identified.

 

[Darrell]

If 255 fields are allowed why do I recieve "Too Many Fields " when I reach
100 to 140.

 

[Duane Hookom]

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.

 

[Jeff Conrad]

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:

 

[Rick Brandt]

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.

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).

 

[Allen Browne]

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.

 

[Darrell]

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