Row limitation

  • Thread starter Thread starter Mary
  • Start date Start date
M

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