If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record Limit
I'm new with Access. Is there a limit to the number of
records you can have in the database? |
#2
|
|||
|
|||
Record Limit
not number of records, but total table size has a limit. open Access Help,
and type specifications you'll get a complete listing of specs for all access objects (everything you ever wanted to know, and more). hth "Sonia" wrote in message ... I'm new with Access. Is there a limit to the number of records you can have in the database? |
#3
|
|||
|
|||
Record Limit
On Wed, 28 Apr 2004 12:06:15 -0700, "Sonia"
wrote: I'm new with Access. Is there a limit to the number of records you can have in the database? No explicit limit on the number of records; 2 GByte (two billion bytes, a *lot* of data) in any single .mdb file. In practice if you have over 10,000,000 records in your largest table you should be seriously looking into client-server. Maybe sooner, maybe later - I know of one Access app with some 50,000,000 records stored in multiple .mdb files. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|