Row limitation

[Mary]

Does Access have a limitation on the number of rows a table can have? I'm
working in both 97 and 2002 versions.

Thanks,
Mary

 

[Mary]

sorry - found the answer! no limit on rows, limited to 2GB.

 

[Jerry Whittle]

We had a contest in these discussion groups a while back. The winner was able
to cram 133 million records in one .MDB file. Of course they were useless
records with just one field and one character or a null value.

 

[Tom van Stiphout]

On Thu, 20 Mar 2008 12:32:01 -0700, Jerry Whittle

Love it. We should have these challenges more often. "Who can create
the fastest routine that does XYZ".

Competitive enough to participate,

-Tom.

 

[aaron.kempf]

Not only do I fully agree. But I htink that I could probably one up
that number.. I'm definitely going to give it a try

I'm down for any competitions you guys want to throw down some code
let me know!

-Aaron

 

[aaron.kempf]

a) If you've got 20 million rows of data, you're going to have _SOME_
duplication
b) partition the data by _DATE_ for example
c) remove the date column
d) presto-chango you've got a _LOT_ more space.
e) who cares if you've got 400 different tables!! you don't need to
repeat the Date column!

I really honestly think that we could beat that if we had only a
single byte column-- this would actually be the basis for a search
engine; if you think about it!

-Aaron