Database size

T

Tony Toews

Anitha said:
What is the limit of an Access 2000 database? How many
records a table could hold?
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Creating a Search using a combo box and then creating a report. 4
Doughnut Chart linked with the slicer in the pivot table 0
Help creating a search form in Access XP 0
Dynamic Naming of Form Button 3
Record capacity Northwind 3
Access Lock File .LACCDB / Now shows as a notepad file 0
Centered text that does not stay centered 0

Top