Mar 13 2007, 01:14 PM
What is the maximum number of fields you should have in a table?
Mar 13 2007, 01:17 PM
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,
Mar 14 2007, 12:20 AM
I'll check those out. Thanks for the information.
Mar 14 2007, 06:42 AM
Good luck with your db..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here