Does anybody know how many rows can Access hold?

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

"Mike" wrote:

> Does anybody know how many rows can Access hold?

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" <(E-Mail Removed)> wrote in message
news:5EEEFA40-07C8-40A4-AAE9-(E-Mail Removed)...
> Does anybody know how many rows can Access hold?

I was asking out of idle curiousity. Thank you!


"Jeff Boyce" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:5EEEFA40-07C8-40A4-AAE9-(E-Mail Removed)...
> > Does anybody know how many rows can Access hold?
>
>
>

On Thu, 23 Apr 2009 11:26:01 -0700, Mike <(E-Mail Removed)>
wrote:

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

John W. Vinson [MVP]