UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Max number of fields?    
 
   
InoAccess
post Mar 13 2007, 01:14 PM
Post #1

UtterAccess Addict
Posts: 273
What is the maximum number of fields you should have in a table?
Go to the top of the page
 
+
MattJ
post Mar 13 2007, 01:17 PM
Post #2

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
While Access limits the number of fields in a table to 255, it is very rare to need this many columns in a properly normalized database. There is no set number that you "should" have in a table - that number is dictated by the data you will be storing and how the different bits of data relate to each other.
Here are a few great links on normalization, which is the process of splitting up your data and defining what tables you will need in a relational database. I strongly suggest you become familiar with the concept,

HTH
Matt


Go to the top of the page
 
+
InoAccess
post Mar 14 2007, 12:20 AM
Post #3

UtterAccess Addict
Posts: 273
I'll check those out. Thanks for the information.
Go to the top of the page
 
+
MattJ
post Mar 14 2007, 06:42 AM
Post #4

UtterAccess VIP
Posts: 4,621
From: North Carolina, USA
np!
Good luck with your db..
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 12:59 PM