Number of Column

R

Rick B

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.
 
J

John Vinson

Can someone tell me how many Columns and Row can a table contain

Thanks

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top