How many fields can be in one Access table?
B Beetle Dec 6, 2008 #2 There is a maximum of 255, however, in a well designed (normalized) application you would not have a table with anywhere near that many fields. In most cases, a table with more than, say, 20-30 fields is most likely improperly structured.
There is a maximum of 255, however, in a well designed (normalized) application you would not have a table with anywhere near that many fields. In most cases, a table with more than, say, 20-30 fields is most likely improperly structured.
P Pete D. Dec 6, 2008 #3 255 and see specifications in help or at http://office.microsoft.com/en-us/access/HP051868081033.aspx
255 and see specifications in help or at http://office.microsoft.com/en-us/access/HP051868081033.aspx
G Guest Dec 6, 2008 #4 Streamliner said: How many fields can be in one Access table? Click to expand...
