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