| | |
|
|
|
maximum records |
|---|
| message from =?Utf-8?B?Y3k=?= on 19 May 2004 |
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!!!
|
| John Vinson replied to =?Utf-8?B?Y3k=?= on 19 May 2004 |
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Pieter Wijnen replied to =?Utf-8?B?Y3k=?= on 19 May 2004 |
no max for records
limit is 2GB total for data
theoretical limit of 255 simultatious users
HTH
Pieter
"cy" <anonymous@discussions.microsoft.com> wrote in message
news:FF867A8B-3BEE-45D9-B593-AE8C562B02D2@microsoft.com...
know this because i have just bought a small business which runs mostly
databases!!!
|
|
Archived message: maximum records (MS Access Forms)
