What is the maximum number of records one database can hold? I need to know this because i have just bought a small business which runs mostly databases!!!
See "Specifications" in the online help for all the details, but
there's a 2 GByte (two billion bytes) limit in any single .mdb file.
In practice, the largest production database of which I am aware has
some 50,000,000 records in the largest table. I'd be inclined to look
into client-server solutions once I hit ten million, depending on the
demands of the system.
In addition, if you're running mission-critical 24x7 databases and
need solid reliability, rollbacks, rollups, and other such features,
Access may not be your best bet. Access databases can become
corrupted, and restoring from a disk backup (with the time and data
loss which that entails) may be your only rescue; a full client-server
solution can be much more robust in this regard.
