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