Access rows

  • Thread starter Thread starter Mike
  • Start date Start date
Not sure if by rows you mean fields? But the limit in Access is 255
fields/table.
 
Mike

Access has a size limit, not a row limit.

Are you asking out of idle curiousity, or do you have some numbers you're
working with?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I was asking out of idle curiousity. Thank you!


Jeff Boyce said:
Mike

Access has a size limit, not a row limit.

Are you asking out of idle curiousity, or do you have some numbers you're
working with?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Does anybody know how many rows can Access hold?

I'm aware of actively used databases with in excess of 20,000,000 rows in the
largest table, and I've used several million plus row tables.
 

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

Back
Top