Access 2000 How many records

  • Thread starter Thread starter Jim H
  • Start date Start date
-----Original Message-----
How many records can Access 2000 handle? We need to
manipulate at lesat 42,000.
.
I believe you are safe. The table size maxed at 1 Gig.
Click to expand...
It can easily handle 42K records. I have an access 97
database that currently holds 443,000 RECORDS in one
table.
 
Jim H said:
How many records can Access 2000 handle? We need to
manipulate at lesat 42,000.
Click to expand...

Peanuts.

A friend has 100,000,000 records consisting of the daily closing stock
prices. And he can get to any stocks records in less than a second.
Obviously he has indexed the appropriate fields. <smile>

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