C Cole Davidson Apr 23, 2009 #2 Not sure if by rows you mean fields? But the limit in Access is 255 fields/table.
J Jeff Boyce Apr 23, 2009 #3 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
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 Apr 23, 2009 #4 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 Click to expand...
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 Click to expand...
J John W. Vinson Apr 24, 2009 #5 Does anybody know how many rows can Access hold? Click to expand... 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.
Does anybody know how many rows can Access hold? Click to expand... 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.