Access rows

C

Cole Davidson

Not sure if by rows you mean fields? But the limit in Access is 255
fields/table.
 
J

Jeff Boyce

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
 
M

Mike

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
 
J

John W. Vinson

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