D Dirk Goldgar Jan 31, 2006 #2 denish said: how many records can microsoft access hold in total? Click to expand... http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold
denish said: how many records can microsoft access hold in total? Click to expand... http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold
D david epsom dot com dot au Jan 31, 2006 #3 How big is your hard disk, plus all attached network storage, plus all available offline storage? 'Access' can hold about 50 million records per gigabyte, when using the Jet storage engine. (david)
How big is your hard disk, plus all attached network storage, plus all available offline storage? 'Access' can hold about 50 million records per gigabyte, when using the Jet storage engine. (david)
J Joseph Meehan Jan 31, 2006 #4 denish said: how many records can microsoft access hold in total? Click to expand... No limit to the number. The total size of the file must be smaller than one or two Gig depending on the version.
denish said: how many records can microsoft access hold in total? Click to expand... No limit to the number. The total size of the file must be smaller than one or two Gig depending on the version.
J John Vinson Jan 31, 2006 #5 how many records can microsoft access hold in total? Click to expand... THat's an Access FAQ - gets asked once or twice a week here. There is no explicit limit. A single .mdb file cannot exceed 2 GByte, and you could have a backend database with just one table in it if you wished. In practice, the biggest Access table in production use of which I am aware is over 20,000,000 rows. John W. Vinson[MVP]
how many records can microsoft access hold in total? Click to expand... THat's an Access FAQ - gets asked once or twice a week here. There is no explicit limit. A single .mdb file cannot exceed 2 GByte, and you could have a backend database with just one table in it if you wished. In practice, the biggest Access table in production use of which I am aware is over 20,000,000 rows. John W. Vinson[MVP]
J John Vinson Jan 31, 2006 #6 http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold Click to expand... <click> <boggle> Results 1 - 10 of 18,300 Yep. That's a *frequently* asked question all right! John W. Vinson[MVP]
http://groups.google.com/groups?as_q=how+many+records+can+microsoft+access+hold Click to expand... <click> <boggle> Results 1 - 10 of 18,300 Yep. That's a *frequently* asked question all right! John W. Vinson[MVP]
