If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How many fields are allowed on an Access 2002 table?
How many fields are allowed on an Access table?
|
#2
|
|||
|
|||
255 or about 220 too many.
-- Duane Hookom MS Access MVP "Darrell" wrote in message ... How many fields are allowed on an Access table? |
#3
|
|||
|
|||
255.
That's 3 or 4 times what you could ever need in any normalized table. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Darrell" wrote in message ... How many fields are allowed on an Access table? |
#4
|
|||
|
|||
I can't get to even 140 with ut an error that says I have too many fields
identified. "Duane Hookom" wrote: 255 or about 220 too many. -- Duane Hookom MS Access MVP "Darrell" wrote in message ... How many fields are allowed on an Access table? |
#5
|
|||
|
|||
If 255 fields are allowed why do I recieve "Too Many Fields " when I reach
100 to 140. "Darrell" wrote: How many fields are allowed on an Access table? |
#6
|
|||
|
|||
If I tell you how to create more fields, would you promise to read up on
normalization? http://www.ltcomputerdesigns.com/JCR...abaseDesign101 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. -- Duane Hookom MS Access MVP "Darrell" wrote in message ... I can't get to even 140 with ut an error that says I have too many fields identified. "Duane Hookom" wrote: 255 or about 220 too many. -- Duane Hookom MS Access MVP "Darrell" wrote in message ... How many fields are allowed on an Access table? |
#7
|
|||
|
|||
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 "Darrell" wrote in message: ... I can't get to even 140 with ut an error that says I have too many fields identified. "Duane Hookom" wrote: 255 or about 220 too many. -- Duane Hookom MS Access MVP "Darrell" wrote in message ... How many fields are allowed on an Access table? |
#8
|
|||
|
|||
Jeff Conrad wrote:
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). -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#9
|
|||
|
|||
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Darrell" wrote in message ... If 255 fields are allowed why do I recieve "Too Many Fields " when I reach 100 to 140. "Darrell" wrote: How many fields are allowed on an Access table? |
#10
|
|||
|
|||
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 "Allen Browne" wrote: 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. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Darrell" wrote in message ... If 255 fields are allowed why do I recieve "Too Many Fields " when I reach 100 to 140. "Darrell" wrote: How many fields are allowed on an Access table? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Book recommendations, please | Top Spin | New Users | 2 | March 1st, 2005 12:43 AM |
Access 2003 Doesn’t display sunken fields!!!!! like 2002 | Chris H | Using Forms | 1 | February 21st, 2005 11:04 PM |
Access 2002 question | Maxx Excaliber | Setup, Installing & Configuration | 1 | August 26th, 2004 07:25 PM |
Access 2000 DB in Access 2002 | Tony_VBACoder | General Discussion | 2 | July 28th, 2004 01:23 AM |