General Question about records in a table

[Guest]

I was just wondering, if access has a maximum number of records it can hold
in a given table.

 

[Douglas J Steele]

No, it doesn't.

The only limit is the fact that a single MDB file cannot exceed 2 Gb.

 

[Rick Brandt]

I was just wondering, if access has a maximum number of records it can hold
in a given table.

The maximum is only on the file size. 1GB for Access 97 and older. 2GB for all
newer versions. Assuming Jet (MDB) tables of course.

 

[Tony Toews]

I was just wondering, if access has a maximum number of records it can hold
in a given table.

FWIW a friend a while back had 100,000,000 records in a table. Daily
closing stock prices for a few years. Fully normalized.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[dbahooker]

Tony;

wow that is pretty impressive.

8 years ago I had a bear of a time with a dozen tables that were 5+
million

I would rather chew on razors than reccomend anything like that in MDB

-Aaron