Number of Column

  • Thread starter Thread starter Guest
  • Start date Start date
Use the help file. Look at "Specifications"

There is no limit to the number of "rows" (we call them records in Access).
Only the size of the file is limited.

As far as how many columns (we call them fields) you *should* not have more
than about 20 or 30 in each table in a properly designed database. You
*can* have many more than that, but Access is a database, not a spreadsheet.

If you need help designing your database, share your ideas and we will help
you divide it into a "normalized" design.
 
Can someone tell me how many Columns and Row can a table contain

Thanks
Click to expand...

255 columns (an absurdly high value, any table with over 60 columns is
probably incorrectly normalized).

No limit on the number of rows other than the 2 billion byte limit to
the total size of a database. I know of Access applications with
20,000,000 rows in a table.

John W. Vinson[MVP]
 
Back
Top