D
Darrell
How many fields are allowed on an Access table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
255 or about 220 too many.
A
Allen Browne
255.
That's 3 or 4 times what you could ever need in any normalized table.
That's 3 or 4 times what you could ever need in any normalized table.
D
Darrell
I can't get to even 140 with ut an error that says I have too many fields
identified.
identified.
D
Darrell
If 255 fields are allowed why do I recieve "Too Many Fields " when I reach
100 to 140.
100 to 140.
D
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.
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.
J
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:
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:
R
Rick Brandt
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.
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).
A
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.
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.
D
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
Thanks for the information and advice. when you'r just learining this stuff
I found the manuals don't tell all.
Darrell