How many registries is MS Access able to manage?

P

Pilgrim37

I want to know how much information is Access able to manage (space on disk,
regsitries) without performance being affected
 
T

Tony Toews

Pilgrim37 said:
I want to know how much information is Access able to manage (space on disk,
regsitries) without performance being affected

What do you mean by registries? data MDBs?

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
 
J

John Vinson

I want to know how much information is Access able to manage (space on disk,
regsitries) without performance being affected

Without performance being *affected*? None, of course. <g>

The limit to the size of a single .mdb file is 2 GBytes. I'm aware of
at least two Access databases (one in Access 2.0!) with over
20,000,000 records in one or more tables. As a rule of thumb, I'd
start looking into client-server software when the database reaches
1.0 or 1.25 GBytes or five million rows; but the decision would vary
greatly depending on your particular application.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top